Get number of free connections in connection pool

Question

In my project Spring manages connection pool with org.apache.commons.dbcp.BasicDataSource class. Is possible to get how many connections are free or used in current time?

Thanks.

Answer 1

To get an instance of BasicDataSource you can use JMX and access the exposed beans. For example you can use Java Visual VM which is bundled with JDK since version 6, update 7. Of course you must install the MBeans plugin.

Answer 2

From the javadocs, you should be able to read this from the getNumIdle() and getNumActive() methods, if you can get an instance of the BasicDataSource.