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 ?