Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Could not retrieve connection info from pool

 
Anurag Mishra
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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----
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic