JDBC Metrics

[indra_joy]

Hi,

Is there any MBean or can we get these values from jmx_console

1. JDBC Connection Pool Wait
2. JDBC Connection Pool Wait Threads
3.JDBC Client Wait Time
4.JDBC Client Wait Time Threads
5. JDBC Connection Pool Timeout
6. JDBC Connection Pool Timeout Threads
7. JDBC Connection Throughput

Thanks in advance. Any help will be really a favor.

Indrajoy

[peterj]

Try jboss.jca:name=XXX,service=ManagedConnectionPool where XXX is the JDNI name of your data source.

[indra_joy]

Thanks peter. I already checked that before but it gives only
1. AvailableConnectionCount
2. ConnectionCount
3. MaxConnectionsInUseCount
4. InUseConnectionCount
5. ConnectionCreatedCount
6. ConnectionDestroyedCount

I am trying to explain more.
JDBC Connection Pool Wait: Average number of connections waiting in the pool.

JDBC Connection Pool Wait Threads:Drill Down View of threads waiting for a connection from the pool.

JDBC Client Wait Time:Average time that a client waits for a connection from the pool

JDBC Client Wait Time Threads:Drill Down View of threads waiting for a connection from the pool.

JDBC Connection Pool Timeout:Number of times a client waited for a connection

JDBC Connection Pool Timeout Threads:Drill Down View of threads that timed out after waiting for a connection from the pool

JDBC Connection Throughput:Number of connections allocated to and returned by applications

Can you please help me in this.

[peterj]

I do not know of anything that keeps those specific statistics.

[indra_joy]

I am wondering is there any tool which keeps track of all this?? Any clue sir

[peterj]

If the code is not tracking this data, then no tool will have access to the data either. Every tool I know of uses the data provided by the MBeans.