Configuring the JDBC Connection Pool

The Application Server uses JDBC to store and retrieve HADB data. For best performance, configure the JDBC connection pool for the fastest possible HADB read/write operations.

Configure the JDBC connection pool in the Admin Console under Resources > JDBC > Connection Pools > pool-name. The connection pool configuration settings are:

• Initial and Minimum Pool Size: Minimum and initial number of connections maintained in the pool (default is 8)

• Maximum Pool Size: Maximum number of connections that can be created to satisfy client requests (default is 32)

• Pool Resize Quantity: Number of connections to be removed when idle timeout timer expires

• Idle Timeout: Maximum time (seconds) that a connection can remain idle in the pool. (default is 300)

• Max Wait Time: Amount of time (milliseconds) caller waits before connection timeout is sent

For optimal performance, use a pool with eight to 16 connections per node. For example, if you have four nodes configured, then the steady-pool size must be set to 32 and the maximum pool size must be 64. Adjust the Idle Timeout and Pool Resize Quantity values based on monitoring statistics.

For the best performance, use the following settings:

• Connection Validation: Required

• Validation Method: metadata

• Transaction Isolation Level: repeatable-read

In addition to the standard attributes, add the two following properties:

• cacheDatabaseMetaData: false

• eliminateRedundantEndTransaction: true

To add a property, click the Add Property button, then specify the property name and value, and click Save.

For more information on configuring the JDBC connection pool, see Tuning JDBC Connection Pools.