wood burning stoves 2.0*
The moose likes JDBC and the fly likes Could not retrieve connection info from pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Could not retrieve connection info from pool" Watch "Could not retrieve connection info from pool" New topic
Author

Could not retrieve connection info from pool

Anurag Mishra
Ranch Hand

Joined: Sep 27, 2001
Posts: 133
Hi,
I am using Apache Torque for making connection with my Oracle 9i server.
My Torque.properties file configuration is as follows:-

torque.dsfactory.cpm.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.cpm.pool.maxActive=10
torque.dsfactory.cpm.pool.maxWait=60
torque.dsfactory.cpm.pool.testOnBorrow=true
torque.dsfactory.cpm.pool.validationQuery=SELECT 1 from dual
torque.dsfactory.cpm.connection.driver = oracle.jdbc.driver.OracleDriver

I am getting the following error:-

Caused by: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:169)

According to me the cause of error is because of the database connection was not available in the connection pool. Or it might be due to The connection was not closed properly becuase of the some issue in the persistent layer.

My Research till now:-

Checked all the connection object properly closed in my classes as well as Torque Classes.
---------------------------------------
Do anyone have any idea regarding this error. If yes, please suggest some solution for it.

----Anurag----
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Could not retrieve connection info from pool
 
Similar Threads
Connection not getting closed in websphere
NoIntialContexException
WebSphere community edition 1.0.1.2 Database Pools connection problem
ERROR: "Could not retrieve connection info from pool"
~~ Newbie question - database ~~