Managing Connector Connection Pools

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.pool-resize-quantity=3

To Edit Connector Connection Pool Advanced Attributes

1Use 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.

 

 

Chapter 7 • Connector Resources

85

Page 85
Image 85
Sun Microsystems 820433510 manual To Edit Connector Connection Pool Advanced Attributes