Managing Connector Connection Pools

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.

 

 

Lazy Connection

Enable this option to enlist a resource to the transaction only when it is actually

Enlistment

used in a method.

 

 

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 it, thereby not incurring the overhead of getting a connection from

 

the pool. Default value is false.

 

 

Match Connections

Use this option to switch on/off connection matching for the pool. It can be set to

 

false if the administrator knows that the connections in the pool will always be

 

homogeneous and hence a connection picked from the pool need not be matched

 

by the resource adapter. Default value is false.

 

 

Max Connection Usage

Specify 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 instance, to avoid statement-leaks. The default value of 0 implies that

 

this attribute is not enabled.

 

 

2Click Save for the changes to take effect.

3Click Load Defaults if you want to restore the default values of all the settings.

More Information Using the asadmin commands to change connection pool properties.

You can use the asadmin get and set commands to view and change the values of the connection pool properties.

To list all the connector connection pools in the server: asadmin list domain.resources.connector-connection-pool.*

To view the properties of the connector connection pool, you can use the following command: asadmin get domain.resources.connector-connection-pool.conectionpoolname.*

To set a property of the connector connection pool, you can use the following command:

asadmin set domain.resources.connector-connection-pool.conectionpoolname.validate-atmost-once-period-in-seconds=

86

Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008

Page 86
Image 86
Sun Microsystems 820433510 manual Pool. Default value is false