[opencms-dev] problem with pool (OpenCMS 7.0.3 + JBoss 4 + Oracle 9 )

[Shi Yusen]

We merged the performance module into OpenCms-jBPM module. I have just
released a new version of source code of OpenCms-jBPM module. You can
find some changes in the following files are for improving OpenCms
performance:
/src/org/opencms/file/CmsObject.java
/src/org/opencms/file/CmsResourceFilter.java
/src/org/opencms/db/CmsDriverManager.java
/src/org/opencms/db/I_CmsVfsDriver.java
/src/org/opencms/db/generic/*.*
/src/org/opencms/db/mysql/*.*
/src/org/opencms/db/oracle/*.*

If you use the new methods in CmsObject, the connection problem will
disappear :).

You can find the module here:
http://www.langhua.cn/en/projects/opencms-jbpm.html

Merry X'mas,

Shi Yusen/Beijing Langhua Ltd.


在 2008-12-19五的 10:49 +0100，Chema写道：
> Hi Everyone,
> I have a problem on Opencms. I installed Opencms 7.0.3 + JBoss 4 on
> the Ubuntu 7 server with Oracle 9.
> I have stressed OpenCMS until it comes out this error, and does not
> release connections, until it locks JBoss.
> 
> Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
> when executing the following query: .
>   at
> org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)
>   at
> org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6323)
>   at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5730)
>   at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3953)
>   ... 34 more
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
> connection, pool error: Timeout waiting for idle object
>   at
> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
>   at java.sql.DriverManager.getConnection(DriverManager.java:525)
>   at java.sql.DriverManager.getConnection(DriverManager.java:193)
>   at
> org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
>   at
> org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
>   at
> org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1880)
>   ... 37 more
> Caused by: java.util.NoSuchElementException: Timeout waiting for idle
> object
>   at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
>   at
> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
>   ... 42 more
> 15:22:54,754 WARN [CmsDriverManager] An SQL error occurred when
> executing the following query: .
> org.opencms.db.CmsDbSqlException: An SQL error occurred when executing
> the following query: .
> 
>     Thanks for any help, 
> 
> 
> 
> 
> ______________________________________________________________________
> Organiza y edita tus fotos con Windows Live Galería fotográfica
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev