Could not retrieve connection info from torque connection pool

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-

[1269 byte] By [anumishra1a] at [2007-10-2 12:35:43]