WAS40ConnectionPool Definition

WAS40ConnectionPool

An optional set of connection pool settings. Default values are provided. Reviewing and possible modification of these config values is recommended.

Attributes Summary

minimumPoolSize The minimum number of connections to maintain in the pool.

maximumPoolSize The maximum number of connections to maintain in the pool.

connectionTimeout Number of milliseconds after which a connection request is determined to have timed out and a ResourceAllocationException is thrown.

idleTimeout The maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.

orphanTimeout The maximum number of seconds that an application can hold a connection without using it before the connection is returned to the pool.

statementCacheSize Maximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.

disableAutoConnectionCleanup Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction.

Attribute Details

minimumPoolSize
The minimum number of connections to maintain in the pool.

Data type: Integer
Default value: unspecified

maximumPoolSize
The maximum number of connections to maintain in the pool. If the maximum number of connections is reached and all connections are in use, additional requests for a connection wait up to the number of seconds specified as the connection timeout.

Data type: Integer
Default value: unspecified

connectionTimeout
Number of milliseconds after which a connection request is determined to have timed out and a ResourceAllocationException is thrown. The wait might be necessary if the maximum value of connections has been reached (MaxConnections). This value has no meaning if the maximum connections property has not been set. If the connection timeout is set to DEFAULT_CONNECTION_TIMEOUT, the ResourceAllocationException is thrown immediately after the pool manager determines that the maximum number of connections has been used. If the connection timeout is set to DISABLE_CONNECTION_TIMEOUT, the pool manager waits until a connection can be allocated. (In other words, it waits until the number of connections falls below the maximum connections).

Data type: Integer
Default value: unspecified

idleTimeout
The maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.

Data type: Integer
Default value: unspecified

orphanTimeout
The maximum number of seconds that an application can hold a connection without using it before the connection is returned to the pool.

Data type: Integer
Default value: unspecified

statementCacheSize
Maximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.

Data type: Integer
Default value: 10

disableAutoConnectionCleanup
Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction. This is needed if you want to hold on to and reuse the same connection across multiple transactions. When this is set make sure to close the connection when you are through using it.

Data type: Boolean
Default value: false

Attributes Summary
minimumPoolSize	The minimum number of connections to maintain in the pool.
maximumPoolSize	The maximum number of connections to maintain in the pool.
connectionTimeout	Number of milliseconds after which a connection request is determined to have timed out and a ResourceAllocationException is thrown.
idleTimeout	The maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.
orphanTimeout	The maximum number of seconds that an application can hold a connection without using it before the connection is returned to the pool.
statementCacheSize	Maximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.
disableAutoConnectionCleanup	Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction.