Sun Microsystems 820434310 Resources, Jdbc Connection Pool Settings, Tuning Jdbc Connection Pools

Resources

is not offered in a Unix/Linux user interface. However, it is possible to edit the OS-scheduled thread pools and add new thread pools, if needed, using the Admin Console.

Resources

■“JDBC Connection Pool Settings” on page 77

■“Connector Connection Pool Settings” on page 80

JDBC Connection Pool Settings

For optimum performance of database-intensive applications, tune the JDBC Connection Pools managed by the Enterprise Server. These connection pools maintain numerous live database connections that can be reused to reduce the overhead of opening and closing database connections. This section describes how to tune JDBC Connection Pools to improve performance.

J2EE applications use JDBC Resources to obtain connections that are maintained by the JDBC Connection Pool. More than one JDBC Resource is allowed to refer to the same JDBC Connection Pool. In such a case, the physical connection pool is shared by all the resources.

Monitoring JDBC Connection Pools

Statistics-gathering is enabled by default for JDBC Connection Pools. The following attributes are monitored:

■numConnFailedValidation (count)Number of connections that failed validation.

■numConnUsed (range)Number of connections that have been used.

■numConnFree (count)Number of free connections in the pool.

■numConnTimedOut (bounded range)Number of connections in the pool that have timed out.

To get the statistics, use these commands:

asadmin get --monitor=true

serverInstance.resources.jdbc-connection-pool.*asadmin get

--monitor=true serverInstance.resources.jdbc-connection-pool. poolName.* *

Tuning JDBC Connection Pools

Set JDBC Connection Pool attributes with the Admin Console under Resources > JDBC > Connection Pools > PoolName. The following attributes affect performance:

■“Pool Size Settings” on page 78

Chapter 3 • Tuning the Enterprise Server 77