Are you closing the ResultSet, Statement and Connection in a finally block immediately after they're used?
-Rashmi On 8/12/07, fusion35 <[EMAIL PROTECTED]> wrote: > > context.xml : > <?xml version="1.0" encoding="UTF-8"?> > <!-- The contents of this file will be loaded for each web application --> > <Context path="/PAF" reloadable="true" crossContext="true"> > <Resource auth="Container" defaultAutoCommit="false" > driverClassName="com.mysql.jdbc.Driver" maxActive="0" maxWait="1000" > name="jdbc/PAFDB" password="root" timeBetweenEvictionRunsMillis="60000" > type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/pafdb" > username="root"/> > </Context> > > > The log of error is as under : > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, > pool error Timeout waiting for idle object > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at bsh.Reflect.invokeMethod(Unknown Source) > at bsh.Reflect.invokeObjectMethod(Unknown Source) > at bsh.Name.invokeMethod(Unknown Source) > at bsh.BSHMethodInvocation.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHAssignment.eval(Unknown Source) > at bsh.BSHBlock.evalBlock(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BSHTryStatement.eval(Unknown Source) > at bsh.BSHBlock.evalBlock(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BshMethod.invokeImpl(Unknown Source) > at bsh.BshMethod.invoke(Unknown Source) > at bsh.BshMethod.invoke(Unknown Source) > at bsh.Name.invokeLocalMethod(Unknown Source) > at bsh.Name.invokeMethod(Unknown Source) > at bsh.BSHMethodInvocation.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.Interpreter.eval(Unknown Source) > at bsh.Interpreter.eval(Unknown Source) > at > org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:80) > at > org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:283) > at org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:727) > at > org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:170) > at > org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138) > at > org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:452) > at > org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:370) > Caused by: java.util.NoSuchElementException: Timeout waiting for idle object > at > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825) > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96) > ... 35 more > Data Source : [EMAIL PROTECTED] > Conn before : null > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, > pool error Timeout waiting for idle object > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at bsh.Reflect.invokeMethod(Unknown Source) > at bsh.Reflect.invokeObjectMethod(Unknown Source) > at bsh.Name.invokeMethod(Unknown Source) > at bsh.BSHMethodInvocation.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHAssignment.eval(Unknown Source) > at bsh.BSHBlock.evalBlock(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BSHTryStatement.eval(Unknown Source) > at bsh.BSHBlock.evalBlock(Unknown Source) > at bsh.BSHBlock.eval(Unknown Source) > at bsh.BshMethod.invokeImpl(Unknown Source) > at bsh.BshMethod.invoke(Unknown Source) > at bsh.BshMethod.invoke(Unknown Source) > at bsh.Name.invokeLocalMethod(Unknown Source) > at bsh.Name.invokeMethod(Unknown Source) > at bsh.BSHMethodInvocation.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.BSHPrimaryExpression.eval(Unknown Source) > at bsh.Interpreter.eval(Unknown Source) > at bsh.Interpreter.eval(Unknown Source) > at > org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:80) > at > org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:283) > at org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:727) > at > org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:170) > at > org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138) > at > org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:452) > at > org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:370) > Caused by: java.util.NoSuchElementException: Timeout waiting for idle object > at > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825) > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96) > ... 35 more > > -- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]