CODEWITHSUNDEEP
javaspringconnection-poolingapache-commons-dbcp
sinuhepop
sinuhepop

Reputation: 20336

Get number of free connections in connection pool

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.

Upvotes: 3

Views: 9782

Answers (2)

davorp
davorp

Reputation: 4236

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.

Upvotes: 0

user7094
user7094

Reputation:

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.

Upvotes: 9

Related Questions