[opencms-dev] Problem with Connection Pool

RAJ rajparikh7575 at gmail.com
Thu Sep 7 17:17:08 CEST 2006


Hi All,
        We have installed OpenCms version 6.0.3 on websphere 6.0 and oracle
8.i environment. My problem is, every 2 or 3 days website goes down and
throws following exception. Exception Says Connection pool exhausted. After
resetting the connection pool it works fine for another 2 or 3 day and start
throwing same exception. What
could be the possible reason ?

Thanks
Rupesh

Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: .
 at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java(Compiled
Code))
 at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java(Compiled
Code))
 at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java(Inlined
Compiled Code))
 ... 26 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
 at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java(Compiled
Code))
 at java.sql.DriverManager.getConnection(DriverManager.java(Compiled Code))
 at java.sql.DriverManager.getConnection(DriverManager.java(Inlined Compiled
Code))
 at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java(Inlined
Compiled Code))
 at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java(Compiled
Code))
 at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java(Compiled
Code))
 ... 29 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(
GenericObjectPool.java(Compiled Code))
 ... 35 more
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060907/8b4a3e03/attachment.htm>


More information about the opencms-dev mailing list