Get number of free connections in connection pool

java spring connection-pooling apache-commons-dbcp
sinuhepop picture sinuhepop · Dec 14, 2009 · Viewed 8.7k times · Source

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

user7094 picture user7094 · Dec 14, 2009

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.

Related questions

Spring JDBC connection pool best practices

I have a basic Spring JDBC application with a pretty basic configuration: <bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@1.1.1.1:1521:…

Read More
c3p0 Connection Pool not closing connections

I have a Using c3p0 0.9.1.2 , hibernate 3.2.1.ga and spring 2.5.5. The problem is the database connection doesn't close itself. Here are the logs : [22 mars 2012 12:29:56,091] DEBUG com.mchange.v2.resourcepool.BasicResourcePool ["http-apr-8080"-exec-4] acquire test -- pool is already maxed out. […

Read More
PoolingHttpClientConnectionManager does not release connections

I am using Spring to achieve the following: On a server, I receive data via a REST interface in an XML-Format. I want to transform the data into JSON and POST it to another Server. My code (I removed some …

Read More