Attribute Description
Validate Atmost Once Amount of time,in seconds, after which a
connection is validatedat most once. This will help
reduce the numberof validation requests by a
connection. The defaultvalue 0 implies that
connection validation isnot enabled.
Leak Timeout Amount of time,in seconds, to trace connection
leaks in aconnection pool. The default value 0
means that connectionleak tracing is disabled. If
connection leak tracingis enabled, you can get
statistics on thenumber of connection leaks in the
MonitoringResources tab. To view this tab,go to
Application Server >Monitoring > Resources.
Leak Reclaim If thisoption is enabled, leaked connections willbe
restored to thepool after leak connection tracing is
complete.
Creation Retry Attempts Number of attemptsthat will be made if thereis a
failure in creatinga new connection. The default
value of 0implies that no attempts will bemade to
create the connectionagain.
Retry Interval Specify the interval,in seconds, between two
attempts to createa connection. The default value is
10 seconds. Thisattribute is used only if thevalue of
Creation Retry Attemptsis greater than 0.
Lazy Connection Enlistment Enable this optionto enlist a resource to the
transaction only whenit is actually used in a
method.
Lazy Association Connections are lazilyassociated when an operation
is performed onthem. Also, they are disassociated
when the transactionis completed and a component
method ends, whichhelps reuse of the physical
connections. Default value isfalse.
Associate withThread Enable this option to associate aconnection with the
thread such thatwhen the same thread is inneed of
a connection, itcan reuse the connection already
associated with thatthread, thereby not incurring
the overhead ofgetting a connection from the pool.
Default value is false.
Workingwith JDBCConnectionPools
Chapter3 • JDBCResources 51