com.ibm.as400.access

Class AS400JDBCConnectionPoolDataSource

java.lang.Object

com.ibm.as400.access.AS400JDBCDataSource

com.ibm.as400.access.AS400JDBCConnectionPoolDataSource

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, java.sql.Wrapper, javax.naming.Referenceable, javax.sql.CommonDataSource, javax.sql.ConnectionPoolDataSource, javax.sql.DataSource

public class AS400JDBCConnectionPoolDataSource
extends AS400JDBCDataSource
implements javax.sql.ConnectionPoolDataSource, javax.naming.Referenceable, java.io.Serializable

The AS400JDBCConnectionPoolDataSource class represents a factory for AS400PooledConnection objects.

The following is an example that creates an AS400JDBCConnectionPoolDataSource object that can be used to cache JDBC connections.

  // Create a data source for making the connection.
  AS400JDBCConnectionPoolDataSource dataSource = new AS400JDBCConnectionPoolDataSource("myAS400");
  datasource.setUser("myUser");
  datasource.setPassword("MYPWD");

  // Get the PooledConnection.
  PooledConnection pooledConnection = datasource.getPooledConnection();
  

See Also:

Serialized Form

Field Summary

Fields inherited from class com.ibm.as400.access.AS400JDBCDataSource

CONCURRENTACCESS_NOT_SET, CONCURRENTACCESS_SKIP_LOCKS, CONCURRENTACCESS_USE_CURRENTLY_COMMITTED, CONCURRENTACCESS_WAIT_FOR_OUTCOME, MAX_STORAGE_LIMIT, SERVER_TRACE_DEBUG_SERVER_JOB, SERVER_TRACE_SAVE_SERVER_JOBLOG, SERVER_TRACE_SAVE_SQL_INFORMATION, SERVER_TRACE_START_DATABASE_MONITOR, SERVER_TRACE_TRACE_SERVER_JOB

Constructor Summary

Constructors

Constructor and Description
AS400JDBCConnectionPoolDataSource() Constructs a default AS400JDBCConnectionPoolDataSource object.
AS400JDBCConnectionPoolDataSource(AS400 as400)
AS400JDBCConnectionPoolDataSource(java.lang.String serverName) Constructs an AS400JDBCConnectionPoolDataSource with the specified serverName.
AS400JDBCConnectionPoolDataSource(java.lang.String serverName, java.lang.String user, char[] password) Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information.
AS400JDBCConnectionPoolDataSource(java.lang.String serverName, java.lang.String user, java.lang.String password) Deprecated. Use AS400JDBCConnectionPoolDataSource(String serverName, String user, char[] password) instead.
AS400JDBCConnectionPoolDataSource(java.lang.String serverName, java.lang.String user, java.lang.String password, java.lang.String keyRingNameX, java.lang.String keyRingPasswordX) Deprecated. -- keyrings are not supported.

Method Summary

Methods

Modifier and Type	Method and Description
javax.sql.PooledConnection	getPooledConnection() Returns a pooled connection that is connected to the IBM i system.
javax.sql.PooledConnection	getPooledConnection(java.lang.String user, char[] password) Returns a pooled connection that is connected to the IBM i system.
javax.sql.PooledConnection	getPooledConnection(java.lang.String user, java.lang.String password) Deprecated. Use getPooledConnection(String user, char[] password) instead.
javax.naming.Reference	getReference() Returns the Reference object for the data source object.
protected java.lang.String[]	getValidWrappedList()

Methods inherited from class com.ibm.as400.access.AS400JDBCDataSource

addPropertyChangeListener, clone, getAccess, getAffinityFailbackInterval, getBehaviorOverride, getBidiStringType, getBlockCriteria, getBlockSize, getCharacterTruncation, getClientRerouteAlternatePortNumber, getClientRerouteAlternateServerName, getConcurrentAccessResolution, getConnection, getConnection, getConnection, getCursorSensitivity, getDatabaseName, getDataSourceName, getDateFormat, getDateSeparator, getDecfloatRoundingMode, getDecimalDataErrors, getDecimalSeparator, getDescribeOption, getDescription, getDriver, getEnableClientAffinitiesList, getEnableSeamlessFailover, getErrors, getIgnoreWarnings, getKeepAlive, getLibraries, getLobThreshold, getLoginTimeout, getLogWriter, getMaximumBlockedInputRows, getMaximumPrecision, getMaximumScale, getMaxRetriesForClientReroute, getMetadataSource, getMetaDataSource, getMinimumDivideScale, getNaming, getNumericRangeError, getPackage, getPackageCcsid, getPackageCCSID, getPackageCriteria, getPackageError, getPackageLibrary, getPortNumber, getProxyServer, getQaqqinilib, getQaqqiniLibrary, getQueryOptimizeGoal, getQueryReplaceTruncatedParameter, getQueryStorageLimit, getQueryTimeoutMechanism, getReceiveBufferSize, getRemarks, getRetryIntervalForClientReroute, getSecondaryUrl, getSecondaryURL, getSendBufferSize, getServerName, getServerTrace, getServerTraceCategories, getSocketTimeout, getSoLinger, getSort, getSortLanguage, getSortTable, getSortWeight, getSoTimeout, getTcpNoDelay, getTimeFormat, getTimeSeparator, getTimestampFormat, getToolboxTrace, getToolboxTraceCategory, getTransactionIsolation, getTranslateHex, getUser, getVariableFieldCompression, getXALooselyCoupledSupport, isAutoCommit, isAutocommitException, isBidiImplicitReordering, isBidiNumericOrdering, isBigDecimal, isCursorHold, isDataCompression, isDataTruncation, isExtendedDynamic, isExtendedMetadata, isExtendedMetaData, isFullOpen, isHoldInputLocators, isHoldStatements, isJvm16Synchronize, isKeepAlive, isLazyClose, isPackageAdd, isPackageCache, isPackageClear, isPrefetch, isPrompt, isRollbackCursorHold, isSavePasswordWhenSerialized, isSecure, isSecureCurrentUser, isTcpNoDelay, isThreadUsed, isTrace, isTranslateBinary, isTranslateBoolean, isTrueAutocommit, isTrueAutoCommit, isUseBlockUpdate, isUseDrdaMetadataVersion, isVariableFieldCompression, removePropertyChangeListener, setAccess, setAffinityFailbackInterval, setAutoCommit, setAutocommitException, setBehaviorOverride, setBidiImplicitReordering, setBidiNumericOrdering, setBidiStringType, setBigDecimal, setBlockCriteria, setBlockSize, setCharacterTruncation, setClientRerouteAlternatePortNumber, setClientRerouteAlternateServerName, setConcurrentAccessResolution, setCursorHold, setCursorSensitivity, setDatabaseName, setDataCompression, setDataSourceName, setDataTruncation, setDateFormat, setDateSeparator, setDecfloatRoundingMode, setDecimalDataErrors, setDecimalSeparator, setDescribeOption, setDescription, setDriver, setEnableClientAffinitiesList, setEnableSeamlessFailover, setErrors, setExtendedDynamic, setExtendedMetadata, setExtendedMetaData, setFullOpen, setHoldInputLocators, setHoldStatements, setIgnoreWarnings, setJvm16Synchronize, setKeepAlive, setLazyClose, setLibraries, setLobThreshold, setLoginTimeout, setLogWriter, setMaximumBlockedInputRows, setMaximumPrecision, setMaximumScale, setMaxRetriesForClientReroute, setMetadataSource, setMetaDataSource, setMinimumDivideScale, setNaming, setNumericRangeError, setPackage, setPackageAdd, setPackageCache, setPackageCcsid, setPackageCCSID, setPackageClear, setPackageCriteria, setPackageError, setPackageLibrary, setPassword, setPassword, setPortNumber, setPrefetch, setPrompt, setProperties, setProperties, setProxyServer, setQaqqinilib, setQaqqiniLibrary, setQueryOptimizeGoal, setQueryReplaceTruncatedParameter, setQueryStorageLimit, setQueryTimeoutMechanism, setReceiveBufferSize, setRemarks, setRetryIntervalForClientReroute, setRollbackCursorHold, setSavePasswordWhenSerialized, setSecondaryUrl, setSecondaryURL, setSecure, setSecureCurrentUser, setSendBufferSize, setServerName, setServerTrace, setServerTraceCategories, setSocketTimeout, setSoLinger, setSort, setSortLanguage, setSortTable, setSortWeight, setSoTimeout, setTcpNoDelay, setThreadUsed, setTimeFormat, setTimeSeparator, setTimestampFormat, setToolboxTrace, setToolboxTraceCategory, setTrace, setTransactionIsolation, setTranslateBinary, setTranslateBoolean, setTranslateHex, setTrueAutocommit, setTrueAutoCommit, setUseBlockUpdate, setUseDrdaMetadataVersion, setUser, setVariableFieldCompression, setVariableFieldCompression, setXALooselyCoupledSupport, toString

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface javax.sql.CommonDataSource

getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource()

Constructs a default AS400JDBCConnectionPoolDataSource object.

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource(AS400 as400)

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource(java.lang.String serverName)

Constructs an AS400JDBCConnectionPoolDataSource with the specified serverName.

Parameters:

serverName - The IBM i system name.

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource(java.lang.String serverName,
                                 java.lang.String user,
                                 java.lang.String password)

Deprecated. Use AS400JDBCConnectionPoolDataSource(String serverName, String user, char[] password) instead.

Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information.

Parameters:

serverName - The IBM i system name.

user - The user id.

password - The password.

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource(java.lang.String serverName,
                                 java.lang.String user,
                                 char[] password)

Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information.

Parameters:

serverName - The IBM i system name.

user - The user id.

password - The password.

AS400JDBCConnectionPoolDataSource

public AS400JDBCConnectionPoolDataSource(java.lang.String serverName,
                                 java.lang.String user,
                                 java.lang.String password,
                                 java.lang.String keyRingNameX,
                                 java.lang.String keyRingPasswordX)

Deprecated. -- keyrings are not supported.

Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information to use for SSL communications with the system.

Parameters:

serverName - The IBM i system name.

user - The user id.

password - The password.

keyRingNameX - The key ring class name to be used for SSL communications with the system.

keyRingPasswordX - The password for the key ring class to be used for SSL communications with the system.

Method Detail

getPooledConnection

public javax.sql.PooledConnection getPooledConnection()
                                               throws java.sql.SQLException

Returns a pooled connection that is connected to the IBM i system.

Specified by:

getPooledConnection in interface javax.sql.ConnectionPoolDataSource

Returns:

A pooled connection.

Throws:

java.sql.SQLException - If a database error occurs.

getPooledConnection

public javax.sql.PooledConnection getPooledConnection(java.lang.String user,
                                             char[] password)
                                               throws java.sql.SQLException

Returns a pooled connection that is connected to the IBM i system.

Parameters:

user - The userid for the connection.

password - The password for the connection.

Returns:

A pooled connection.

Throws:

java.sql.SQLException - If a database error occurs.

getPooledConnection

public javax.sql.PooledConnection getPooledConnection(java.lang.String user,
                                             java.lang.String password)
                                               throws java.sql.SQLException

Deprecated. Use getPooledConnection(String user, char[] password) instead.

Returns a pooled connection that is connected to the IBM i system.

Specified by:

getPooledConnection in interface javax.sql.ConnectionPoolDataSource

Parameters:

user - The userid for the connection.

password - The password for the connection.

Returns:

A pooled connection.

Throws:

java.sql.SQLException - If a database error occurs.

getReference

public javax.naming.Reference getReference()
                                    throws javax.naming.NamingException

Returns the Reference object for the data source object. This is used by JNDI when bound in a JNDI naming service. Contains the information necessary to reconstruct the data source object when it is later retrieved from JNDI via an object factory.

Specified by:

getReference in interface javax.naming.Referenceable

Overrides:

getReference in class AS400JDBCDataSource

Returns:

A Reference object for the data source object.

Throws:

javax.naming.NamingException - If a naming error occurs resolving the object.

getValidWrappedList

protected java.lang.String[] getValidWrappedList()

Overrides:

getValidWrappedList in class AS400JDBCDataSource