File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connection pool metrics Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection pool metrics" Watch "Connection pool metrics" New topic

Connection pool metrics

Ramu Nur

Joined: Aug 21, 2010
Posts: 22
I need to get connection pool metrics like DB connections that are active, passive/inactive and blocked, total available connections from DB etc for the applciation deployment capacity planning. I came across some tools like Proxool, DBPool etc, but don't give much details. We use DBCP that doesn't have any Listerners to implement.

I see one option of writing my own JDBC connection/statement, etc and override some methods, but that becomes cumbersome design for maintenance. Do you see any approach to get the metrics ?

I agree. Here's the link:
subject: Connection pool metrics
It's not a secret anymore!