Stefano
|
| Posted: 10/03/2005, 6:36 AM |
|
We've got a problem connecting with a Oracle 9.2.0 via Codecharge's connection pool. When our webapplication starts it runs just fine, but after a while (and after it's been used by some user) it starts throwing exceptions like this one:
2005-10-03 09:31:48 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Unable to create connection 'DBConn' to the database.
at com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:19)
at com.codecharge.db.JDBCConnection.<init>(JDBCConnection.java:80)
at com.codecharge.db.PoolJDBCConnection.<init>(PoolJDBCConnection.java:11)
at com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:36)
at com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:27)
at com.codecharge.db.DBTools.dLookUp(DBTools.java:12)
...
It's not a DB problem: the other webapps hosted on the same server, and the ones hosted on the other server (using identical HW) keep running fine when this problem occurs, and it's sufficient to restart the stuck webapp to make it disappear. It doesn't happen with just one webapp, but with almost all of them: the more the single webapp is used, the sooner this problem will present itself.
We noticed that this happens more often if we keep the parameter DBConn.maxconn low.
Any idea about possible causes of this? Is anyone having similar problems?
We are using CodeCharge Studio 2.3.2.24
jdbc drivers: oracle.jdbc.driver.OracleDriver
Thanx in advance,
Stefano
|
