Attribute Description
ValidateAtmost Once Amountof time, in seconds, after which a
connectionis validated at most once. This will help
reducethe number of validation requests by a
connection.The default value 0 implies that
connectionvalidation is not enabled.
LeakTimeout Amountof time, in seconds, to trace connection
leaksin a connection pool. The default value 0
meansthat connection leak tracing is disabled. If
connectionleak tracing is enabled, you can get
statisticson the number of connection leaks in the
MonitoringResources tab. To view this tab, go to
ApplicationServer > Monitoring > Resources.
LeakReclaim If this option is enabled, leaked connections will be
restoredto the pool after leak connection tracing is
complete.
CreationRetry Attempts Numberof attempts that will be made if there is a
failurein creating a new connection. The default
valueof 0 implies that no attempts will be made to
createthe connection again.
RetryInterval Specifythe interval, in seconds, between two
attemptsto create a connection. The default value is
10seconds. This attribute is used only if the value of
CreationRetry Attempts is greater than 0.
LazyConnection Enlistment Enablethis option to enlist a resource to the
transactiononly when it is actually used in a
method.
LazyAssociation Connectionsare lazily associated when an operation
isperformed on them. Also, they are disassociated
whenthe transaction is completed and a component
methodends, which helps reuse of the physical
connections.Default value is false.
Associatewith Thread Enablethis option to associate a connection with the
threadsuch that when the same thread is in need of
aconnection, it can reuse the connection already
associatedwith that thread, thereby not incurring
theoverhead of getting a connection from the pool.
Defaultvalue is false.
WorkingwithJDBC Connection Pools
Chapter3 • JDBC Resources 51