Working with JDBC Connection Pools

 

 

 

 

 

 

 

Attribute

Description

 

 

 

 

Validate Atmost Once

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 default value 0 implies that

 

 

connection validation is not enabled.

 

 

 

 

Leak Timeout

Amount of time, in seconds, to trace connection

 

 

leaks in a connection pool. The default value 0

 

 

means that connection leak tracing is disabled. If

 

 

connection leak tracing is enabled, you can get

 

 

statistics on the number of connection leaks in the

 

 

Monitoring Resources tab. To view this tab, go to

 

 

Application Server > Monitoring > Resources.

 

 

 

 

Leak Reclaim

If this option is enabled, leaked connections will be

 

 

restored to the pool after leak connection tracing is

 

 

complete.

 

 

 

 

Creation Retry Attempts

Number of attempts that will be made if there is a

 

 

failure in creating a new connection. The default

 

 

value of 0 implies that no attempts will be made to

 

 

create the connection again.

 

 

 

 

Retry Interval

Specify the interval, in seconds, between two

 

 

attempts to create a connection. The default value is

 

 

10 seconds. This attribute is used only if the value of

 

 

Creation Retry Attempts is greater than 0.

 

 

 

 

Lazy Connection Enlistment

Enable this option to enlist a resource to the

 

 

transaction only when it is actually used in a

 

 

method.

 

 

 

 

Lazy Association

Connections are lazily associated when an operation

 

 

is performed on them. Also, they are disassociated

 

 

when the transaction is completed and a component

 

 

method ends, which helps reuse of the physical

 

 

connections. Default value is false.

 

 

 

 

Associate with Thread

Enable this option to associate 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.

 

 

Default value is false.

 

 

 

Chapter 3 • JDBC Resources

51

Page 51
Image 51
Sun Microsystems 820433510 manual Creation Retry Attempts is greater than