JDBC Programmer Reference › DataSource Connection Parameters › IdmsConnectionPoolDataSource

IdmsConnectionPoolDataSource

The IdmsConnectionPoolDataSource class implements the JDBC ConnectionPoolDataSource interface. It is used with an application server that provides container managed connection pooling to establish a pooled connection to a CA IDMS database.

An application server typically provides visible DataSource implementation that references a ConnectionPoolDataSource and is exposed to the application as a standard DataSource. Connection pooling is completely transparent to the application.

IdmsConnectionPoolProperties are used by the application server connection pool manager to administer the pool of connections for a particular data source.

connectSuspend

Specifies the default for a pooled connection is true.

initialPoolSize

Specifies the number of connections that the pool manager should initially allocate.

maxIdleTime

Specifies the interval in seconds that a pooled connection can be idle before it is closed. When set, it increases the resourceInterval value for a Type 4 connection to the value specified plus the value of propertyCycle property. This aligns the task resource interval with the application server idle time so that the CA IDMS system does not terminate an idle pooled connection due to inactivity.

maxPoolSize

Specifies the maximum number of connections that the pool manager should allocate.

maxStatements

Specifies the maximum statement pool size. Note that CA IDMS/DB provides an internal statement caching feature in releases 16.0 and later.

minPoolSize

Specifies the minimum number of available connections that pool manager should maintain.

This property (or the corresponding property within an application server's connection pool definition) should always be set to 0. This avoids potential timeout-related problems between the JDBC connections and their associated tasks and sessions on the CA IDMS/DC system.

propertyCycle

Indicates the interval in seconds the pool manager should wait before enforcing these policies.

Note: For more information about deploying and using DataSource and ConnectionPoolDataSource objects to connect to a database, see JDBC 4.0 Specification, available at www.java.sun.com. Detailed information for these interfaces is included in the JDK "javadoc," available in the same place, and detailed information about the CA IDMS Server implementations methods is included in the installed "javadoc" (and also on the CD in /doc/javadoc.zip).