Edit Connection Pool Advanced Attributes

To help diagnose connection leaks and improve ease-of–use, advanced attributes are provided to configure a connection pool at the time of its creation.

The Edit Connection Pool Advanced Attributes page has the following options.

Name

A read-only field identifying the name for the connection pool.

Statement Timeout

The length of time, in seconds, after which abnormally long running queries will be terminated. Enterprise Server will set QueryTimeout on the statements created. A value of –1 means that the option is disabled. The default value is –1.

Wrap JDBC Objects

When this field is set to true, applications will get wrapped JDBC objects for Statement, PreparedStatement, CallableStatement, ResultSet, DatabaseMetaData. The default value is false.

Validate At Most Once

The amount of time, in seconds, after which a connection is validated at most once. This will help reduce the number of validation requests by a connection. The value of 0 means that connection validation is disabled. The default value is 0.

Leak Timeout

The amount of time, in seconds, to trace connection leaks in a connection pool. The default value 0 means that connection leak tracing is disabled.

Leak Reclaim

If enabled, leaked connections will be restored to the pool after leak connection tracing is complete.

Creation Retry Attempts

The number of attempts that will be made if there is a failure in creating a new connection. The value of 0 means that no attempts will be made to create the connection again. The default value is 0.

Retry Interval

The interval of time, in seconds, between two attempts to create a connection. The default value is 10. This attribute is used only if the value of Creation Retry Attempts is greater than 0.

Lazy Association

If enabled, connections are lazily associated when an operation is performed on them. Connections are disassociated when the transaction is completed and a component method ends, which helps reuse of the physical connections. This option is disabled by default.

Lazy Connection Enlistment

If enabled, a resource to the transaction is enlisted only when it is actually used in a method.

Associate with Thread

If enabled, an association is made between a connection with the thread such that when the same thread is in need of a connection, it can reuse the connection already associated with that thread, thereby not incurring the overhead of getting a connection from the pool. This option is disabled by default.

Match Connections

If enabled, the connection matching for the pool is switched on/off. It can be disabled if the administrator knows that the connections in the pool will always be homogeneous and hence a connection picked from the pool does not need to be matched by the resource adapter. This option is disabled by default.

Max Connection Usage

The number of times that a connection should be reused by the pool. Once a connection is reused for the specified number of times, it will be closed. This is useful, for instance, to avoid statement-leaks. A value of 0 means that this attribute is disabled. The default value is 0.

Related Tasks
Related asadmin Commands