posted 18 years ago
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----