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(java.lang.String serverName)` Constructs an AS400JDBCConnectionPoolDataSource with the specified serverName.
`AS400JDBCConnectionPoolDataSource(java.lang.String serverName, java.lang.String user, java.lang.String password)` Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information.
`AS400JDBCConnectionPoolDataSource(java.lang.String serverName, java.lang.String user, java.lang.String password, java.lang.String keyRingNameX, java.lang.String keyRingPasswordX)` Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information to use for SSL communications with the system.

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, java.lang.String password)` Returns a pooled connection that is connected to the IBM i system.
`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, 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, 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, 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(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)
```
    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)
```
    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,
                                             java.lang.String password)
                                               throws java.sql.SQLException
```
    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

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

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

Methods inherited from class java.lang.Object

Methods inherited from interface javax.sql.CommonDataSource

Methods inherited from interface java.sql.Wrapper

AS400JDBCConnectionPoolDataSource

AS400JDBCConnectionPoolDataSource

AS400JDBCConnectionPoolDataSource

AS400JDBCConnectionPoolDataSource

getPooledConnection

getPooledConnection

getReference

getValidWrappedList