WAS40ConnectionPool

WAS40ConnectionPool

This type is a class for model objects.

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

Classifier ID:  -1
Instance class name:  * Unspecified *
Instance class:  * Unspecified *

Reference attributes having this type:
  WAS40DataSource.connectionPool

Attributes Summary

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

maximumPoolSize : EInt 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.

connectionTimeout : EInt 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).

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

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

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

disableAutoConnectionCleanup : EBoolean Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction. This is needed if we 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.

Attribute Details

minimumPoolSize  -  The minimum number of connections to maintain in the pool.
    Data Type: EInt
    Default value:  unspecified
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

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: EInt
    Default value:  unspecified
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

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: EInt
    Default value:  unspecified
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

idleTimeout  -  The maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.
    Data Type: EInt
    Default value:  unspecified
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

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: EInt
    Default value:  unspecified
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

statementCacheSize  -  Maximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.
    Data Type: EInt
    Default value:  10
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

disableAutoConnectionCleanup  -  Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction. This is needed if we 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: EBoolean
    Default value:  false
    Required:  false
    Changeable:  true
    Unsettable:  true
    Many:  false
    Ordered:  true
    Lower bound:  0
    Upper bound:  1
    Unique:  true
    Derived:  false
    Transient:  false
    Volatile:  false

(C) COPYRIGHT International Business Machines Corp. 1996-2006

Attributes Summary
minimumPoolSize : EInt	The minimum number of connections to maintain in the pool.
maximumPoolSize : EInt	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.
connectionTimeout : EInt	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).
idleTimeout : EInt	The maximum number of seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.
orphanTimeout : EInt	The maximum number of seconds that an application can hold a connection without using it before the connection is returned to the pool.
statementCacheSize : EInt	Maximum number of prepared statements to cache for the DataSource; this limit is shared among all connections; default value is 10.
disableAutoConnectionCleanup : EBoolean	Tells the connection pooling software not to automatically close connections from this datasource at the end of a transaction. This is needed if we 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.