com.ibm.as400.access
Class AS400JDBCConnectionPoolDataSource

java.lang.Object
  |
  +--com.ibm.as400.access.AS400JDBCDataSource
        |
        +--com.ibm.as400.access.AS400JDBCConnectionPoolDataSource

All Implemented Interfaces:

javax.sql.ConnectionPoolDataSource, javax.sql.DataSource, javax.naming.Referenceable, java.io.Serializable

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

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

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 keyRingName, java.lang.String keyRingPassword)
Constructs an AS400JDBCConnectionPoolDataSource with the specified signon information to use for SSL communications with the server.

Method Summary

javax.sql.PooledConnection	getPooledConnection() Returns a pooled connection that is connected to the server.
javax.sql.PooledConnection	getPooledConnection(java.lang.String user, java.lang.String password) Returns a pooled connection that is connected to the server.
javax.naming.Reference	getReference() Returns the Reference object for the data source object.

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

addPropertyChangeListener, getAccess, getBehaviorOverride, getBidiStringType, getBlockCriteria, getBlockSize, getConnection, getConnection, getCursorSensitivity, getDatabaseName, getDataSourceName, getDateFormat, getDateSeparator, getDecimalSeparator, getDescription, getDriver, getErrors, getKeepAlive, getLibraries, getLobThreshold, getLoginTimeout, getLogWriter, getMaximumPrecision, getMaximumScale, getMinimumDivideScale, getNaming, getPackage, getPackageCCSID, getPackageCriteria, getPackageError, getPackageLibrary, getProxyServer, getQaqqiniLibrary, getReceiveBufferSize, getRemarks, getSecondaryUrl, getSendBufferSize, getServerName, getServerTraceCategories, getSoLinger, getSort, getSortLanguage, getSortTable, getSortWeight, getSoTimeout, getTcpNoDelay, getTimeFormat, getTimeSeparator, getToolboxTraceCategory, getTransactionIsolation, getTranslateHex, getUser, isBidiImplicitReordering, isBidiNumericOrdering, isBigDecimal, isCursorHold, isDataCompression, isDataTruncation, isExtendedDynamic, isExtendedMetaData, isFullOpen, isLazyClose, isPackageAdd, isPackageCache, isPackageClear, isPrefetch, isPrompt, isSavePasswordWhenSerialized, isSecure, isThreadUsed, isTrace, isTranslateBinary, isTrueAutoCommit, removePropertyChangeListener, setAccess, setBehaviorOverride, setBidiImplicitReordering, setBidiNumericOrdering, setBidiStringType, setBigDecimal, setBlockCriteria, setBlockSize, setCursorHold, setCursorSensitivity, setDatabaseName, setDataCompression, setDataSourceName, setDataTruncation, setDateFormat, setDateSeparator, setDecimalSeparator, setDescription, setDriver, setErrors, setExtendedDynamic, setExtendedMetaData, setFullOpen, setKeepAlive, setLazyClose, setLibraries, setLobThreshold, setLoginTimeout, setLogWriter, setMaximumPrecision, setMaximumScale, setMinimumDivideScale, setNaming, setPackage, setPackageAdd, setPackageCache, setPackageCCSID, setPackageClear, setPackageCriteria, setPackageError, setPackageLibrary, setPassword, setPrefetch, setPrompt, setProxyServer, setQaqqiniLibrary, setReceiveBufferSize, setRemarks, setSavePasswordWhenSerialized, setSecondaryUrl, setSecure, setSendBufferSize, setServerName, setServerTraceCategories, setSoLinger, setSort, setSortLanguage, setSortTable, setSortWeight, setSoTimeout, setTcpNoDelay, setThreadUsed, setTimeFormat, setTimeSeparator, setToolboxTraceCategory, setTrace, setTransactionIsolation, setTranslateBinary, setTranslateHex, setTrueAutoCommit, setUser, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface javax.sql.ConnectionPoolDataSource

getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

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 name of the iSeries server.

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 iSeries 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 keyRingName,
                                         java.lang.String keyRingPassword)

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

Parameters:

serverName - The iSeries system name.

user - The user id.

password - The password.

keyRingName - The key ring class name to be used for SSL communications with the server.

keyRingPassword - The password for the key ring class to be used for SSL communications with the server.

Method Detail

getPooledConnection

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

Returns a pooled connection that is connected to the server.

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 server.

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.