The Connection Pools page opens.
The Edit Connection Pool page opens.
The Edit Connection Pool Advanced Attributes page opens.
Note - The Name field is a read-only field. You can only specify the connection pool name when you create a new JDBC connection pool.
Enterprise Server will set QueryTimeout on the statements created. Set the value to -1 to disable this option. The default value is -1.
The default value is false.
This will help reduce the number of validation requests by a connection. Set the value to 0 to disable connection validation. The default value is 0.
Set the value to 0 to disable connection leak tracing. The default value is 0.
Set the value to 0 to make no attempts to create the connection again. The default value is 0.
The default value is 10. This attribute is used only if the value of Creation Retry Attempts is greater than 0.
Connections are disassociated when the transaction is completed and a component method ends, which helps the physical connections to be reused. This option is disabled by default.
When the same thread is in need of another connection, it can reuse the connection already associated with that thread, thereby not incurring the overhead of getting another connection from the pool.
This option is disabled by default.
This option can be disabled if the administrator knows that the connections in the pool will always be homogeneous and therefore a connection picked from the pool does not need to be matched by the resource adapter. This option is disabled by default.
Once a connection is reused for the specified number of times, it will be closed. This is useful, for example, to avoid statement-leaks. Set the value to 0 disable this attribute. The default value is 0.