[opencms-dev] SQL Error ???

[Olivier Camus]

Hi list!

Is anybody has an idea of why the following error is raised ?


26 Nov 2007 22:53:46,033 ERROR [.opencms.db.CmsSecurityManager:2488] An
SQL error occurred when executing the following query: . 
	... 46 more
	at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
	... 41 more
	at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1880)
	at
org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
	at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error: Timeout waiting for idle object
	... 39 more
	at
org.opencms.db.generic.CmsUserDriver.getResourcesForOrganizationalUnit(CmsUserDriver.java:857)
	at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6370)
	at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: . 
	at java.lang.Thread.run(Thread.java:595)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:544)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
	at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
	at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
	at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
	at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
	at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:183)
	at
org.opencms.main.OpenCmsServletErrorHandler.doGet(OpenCmsServletErrorHandler.java:81)
	at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)
	at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1487)
	at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2064)
	at
org.opencms.main.OpenCmsCore.initCmsObjectFromSession(OpenCmsCore.java:895)
	at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2013)
	at org.opencms.i18n.CmsLocaleManager.getI18nInfo(CmsLocaleManager.java:767)
	at
org.opencms.i18n.CmsDefaultLocaleHandler.getI18nInfo(CmsDefaultLocaleHandler.java:103)
	at org.opencms.file.CmsObject.readResource(CmsObject.java:3435)
	at org.opencms.file.CmsObject.readResource(CmsObject.java:3468)
	at
org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3960)
	at
org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5765)
	at
org.opencms.db.CmsSecurityManager.checkPermissions(CmsSecurityManager.java:5337)
	at
org.opencms.db.CmsSecurityManager.hasPermissions(CmsSecurityManager.java:5585)
	at
org.opencms.security.CmsDefaultPermissionHandler.hasPermissions(CmsDefaultPermissionHandler.java:87)
	at
org.opencms.db.CmsSecurityManager.hasRoleForResource(CmsSecurityManager.java:2478)
	at
org.opencms.db.CmsDriverManager.getResourcesForOrganizationalUnit(CmsDriverManager.java:3988)
	at
org.opencms.db.generic.CmsUserDriver.getResourcesForOrganizationalUnit(CmsUserDriver.java:860)
org.opencms.file.CmsDataAccessException: An SQL error occurred when
executing the following query: . 

Thank's in advanced !