To Edit JDBC Connection Pool Advanced Attributes

  1. In the navigation tree, expand the Resources node.
  2. Under the Resources node, select the JDBC node.
  3. Under the JDBC node, select the Connection Pools node.

    The Connection Pools page opens.

  4. On the Connection Pools page, click the name of the pool that you are editing.

    The Edit Connection Pool page opens.

  5. On the Edit Connection Pool page, click the Advanced tab.

    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.


  6. In the Statement Timeout field, type the length of time, in seconds, after which abnormally long running queries will be terminated.

    Enterprise Server will set QueryTimeout on the statements created. Set the value to -1 to disable this option. The default value is -1.

  7. Select the Wrap JDBC Objects Enabled option for applications to get wrapped JDBC objects for Statement, PreparedStatement, CallableStatement, ResultSet, DatabaseMetaData.

    The default value is false.

  8. In the Validate At Most Once field, type 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. Set the value to 0 to disable connection validation. The default value is 0.

  9. In the Leak Timeout field, type the amount of time, in seconds, to trace connection leaks in a connection pool.

    Set the value to 0 to disable connection leak tracing. The default value is 0.

  10. Select the Leak Reclaim option to restore leaked connections to the pool after leak connection tracing is complete.
  11. In the Creation Retry Attempts field, type the number of attempts that will be made if there is a failure in creating a new connection.

    Set the value to 0 to make no attempts to create the connection again. The default value is 0.

  12. In the Retry Interval field, type the interval, 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.

  13. Select the Lazy Association Enabled option to lazily associate connections when an operation is performed on them.

    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.

  14. Select the Lazy Connection Enlistment Enabled option to enlist a resource to the transaction only when it is actually used in a method.
  15. Select the Associate with Thread Enabled option to create associations between connections and threads.

    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.

  16. Select the Match Connections Enabled option to enable connection matching for the pool.

    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.

  17. In the Max Connection Usage field, type the number of times 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 example, to avoid statement-leaks. Set the value to 0 disable this attribute. The default value is 0.

See Also