Yes I have closed ResultSet, Statement and Connection > Have you tried to close ResultSet, Statement and Connection after each > use? > > -----Original Message----- > From: Galbayar [mailto:[EMAIL PROTECTED] > Sent: November 10, 2003 4:50 AM > To: Tomcat Users List > Subject: DBCP could not obtain an idle db connection, pool exhausted > > How to solve this problem? > > I'm using > Tomcat 4.1.27 > J2SDK (build 1.4.1_03-b02 > Tyrex 1.0 > Commons DBCP 1.1 > MySQL ConnectorJ version 3.0.8 > > > My server.xml configuration > > <Context ...> > <Resource name="jdbc/sss" auth="Container" type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/sss"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > > <parameter> > <name>maxActive</name> > <value>20</value> > </parameter> > > <parameter> > <name>maxIdle</name> > <value>20</value> > </parameter> > > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > > > <parameter> > <name>username</name> > <value>username</value> > </parameter> > > <parameter> > <name>password</name> > <value>password</value> > </parameter> > > > <parameter> > <name>driverClassName</name> > <value>ocom.mysql.jdbc.Driver</value> > </parameter> > > <parameter> > <name>url</name> > <value>jdbc:mysql://localhost:3306/sss?autoReconnect=true</value> > </parameter> > </ResourceParams> > </Context> > > > > Galbayar. D > Senior software engineer > Mobile Business Development > Business Development Division > > MobiCom Corporation > Peace Avenue 3/1 > P.O Box 20A > Ulaanbaatar 210620 > Mongolia > > > --------------------------------------------------------------------- To > unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]