Sun GlassFish Enterprise Server 2.1 Administration Guide

ProcedureTo Edit Connector Connection Pool Advanced Attributes

  1. Use the Advanced tab to edit the advanced attributes for a connector connection pool.

    Parameter 

    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 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 Enlistment 

    Enable this option to enlist a resource to the transaction only when it is actually 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. 

  2. Click Save for the changes to take effect.

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

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=3