WAS40ConnectionPool

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



Attributes Summary
minimumPoolSize : intThe minimum number of connections to maintain in the pool.
maximumPoolSize : intThe maximum number of connections to maintain in the pool.
connectionTimeout : intNumber of milliseconds after which a connection request is determined to have timed out and a ResourceAllocationException is thrown.
idleTimeout : intThe maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.
orphanTimeout : intThe maximum number of seconds that an application can hold a connection without using it before the connection is returned to the pool.
statementCacheSize : intMaximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.
disableAutoConnectionCleanup : booleanTells 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:  int
     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:  int
     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:  int
     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:  int
     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:  int
     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:  int
     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 you must make sure to close the connection when you are through using it.
     data type: boolean
     default Value:   false
     Allowed Values:  true   false  


Copyright IBM Corp. 1997-2004