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.* *