Hello Olivier,<br><br><div><span class="gmail_quote">On 11/27/07, <b class="gmail_sendername">Olivier Camus</b> <<a href="mailto:olivier.camus@steria.com">olivier.camus@steria.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi list!<br><br>Is anybody has an idea of why the following error is raised ?<br><br><br>26 Nov 2007 22:53:46,033 ERROR [.opencms.db.CmsSecurityManager:2488] An<br>SQL error occurred when executing the following query: .<br>
        ... 46 more<br>        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)<br>        at<br>org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)<br>Caused by: 
java.util.NoSuchElementException: Timeout waiting for idle object</blockquote><div><br>
<br>
It seems a database connection problem. Are you sure your database is
up and running? Can you connect to it from the command line use the
same credential?<br>
<br>
Best<br>
<br>
- RuiXian <br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">        ... 41 more<br>        at org.opencms.db.generic.CmsVfsDriver.readResource
(CmsVfsDriver.java:1880)<br>        at<br>org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)<br>        at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)<br>        at java.sql.DriverManager.getConnection
(DriverManager.java:193)<br>        at java.sql.DriverManager.getConnection(DriverManager.java:525)<br>        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)<br>Caused by: org.apache.commons.dbcp.SQLNestedException
: Cannot get a<br>connection, pool error: Timeout waiting for idle object<br>        ... 39 more<br>        at<br>org.opencms.db.generic.CmsUserDriver.getResourcesForOrganizationalUnit(CmsUserDriver.java:857)<br>        at 
org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6370)<br>        at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
<br>executing the following query: .<br>        at java.lang.Thread.run(Thread.java:595)<br>        at<br>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)<br>        at<br>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFollowerWorkerThread.java:81)<br>        at<br>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br>        at<br>org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:665)<br>        at<br>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)<br>        at<br>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>        at
<br>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>        at<br>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:544)<br>        at<br>org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:117)<br>        at<br>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)<br>        at<br>org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at<br>org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>        at<br>org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>        at<br>org.apache.catalina.core.ApplicationDispatcher.doForward
(ApplicationDispatcher.java:403)<br>        at<br>org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>        at<br>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java
:691)<br>        at<br>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>        at<br>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java
:269)<br>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)<br>        at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java
:183)<br>        at<br>org.opencms.main.OpenCmsServletErrorHandler.doGet(OpenCmsServletErrorHandler.java:81)<br>        at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)<br>        at org.opencms.main.OpenCmsCore.showResource
(OpenCmsCore.java:1487)<br>        at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2064)<br>        at<br>org.opencms.main.OpenCmsCore.initCmsObjectFromSession(OpenCmsCore.java:895)<br>        at org.opencms.main.OpenCmsCore.initCmsObject
(OpenCmsCore.java:2013)<br>        at org.opencms.i18n.CmsLocaleManager.getI18nInfo(CmsLocaleManager.java:767)<br>        at<br>org.opencms.i18n.CmsDefaultLocaleHandler.getI18nInfo(CmsDefaultLocaleHandler.java:103)<br>        at 
org.opencms.file.CmsObject.readResource(CmsObject.java:3435)<br>        at org.opencms.file.CmsObject.readResource(CmsObject.java:3468)<br>        at<br>org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java
:3960)<br>        at<br>org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5765)<br>        at<br>org.opencms.db.CmsSecurityManager.checkPermissions(CmsSecurityManager.java:5337)<br>        at<br>org.opencms.db.CmsSecurityManager.hasPermissions
(CmsSecurityManager.java:5585)<br>        at<br>org.opencms.security.CmsDefaultPermissionHandler.hasPermissions(CmsDefaultPermissionHandler.java:87)<br>        at<br><br>
</blockquote></div><br>