Sun Microsystems 820433510 Usingthe asadmin commands to change connection pool properties.

LazyAssociation Connectionsare lazily associated when an operation is performed on them. Also,
theyare disassociated when the transaction is completed and a component
methodends, which helps reuse of the physical connections. Default value is false.
LazyConnection
Enlistment
Enablethis option to enlist a resource to the transaction only when it is actually
usedin a method.
Associatewith Thread Enablethis option to associate a connection with the thread such that when the
samethread is in need of a connection, it can reuse the connection already
associatedwith it, thereby not incurring the overhead of getting a connection from
thepool. Default value is false.
MatchConnections Usethis option to switch on/o connection matching for the pool. It can be set to
falseif the administrator knows that the connections in the pool will always be
homogeneousand hence a connection picked from the pool need not be matched
bythe resource adapter. Default value is false.
MaxConnection Usage Specifythe number of times a connection should be reused by the pool. Once a
connectionis reused for the specied number of times, it will be closed. This is
useful,for instance, to avoid statement-leaks. The default value of 0 implies that
thisattribute is not enabled.
ClickSave for the changes to take eect.
ClickLoad Defaults if you want to restorethe default values of all the settings.
Usingthe asadmin commands to change connection pool properties.
Youcan use the asadmin get and set commands to view and change the values of the
connectionpool properties.
Tolist all the connector connection pools in the server:
asadminlist domain.resources.connector-connection-pool.*
Toview the properties of the connector connection pool, you can use the following command:
asadminget domain.resources.connector-connection-pool.conectionpoolname.*
Toset a property of the connector connection pool, you can use the following command:
asadminset
domain.resources.connector-connection-pool.conectionpoolname.validate-atmost-once-period-in-seconds=3
2
3
MoreInformation
ManagingConnectorConnection Pools
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200886