• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Could not retrieve connection info from pool

 
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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----
 
A lot of people cry when they cut onions. The trick is not to form an emotional bond. This tiny ad told me:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic