Maybe our problem here is the DBCP itself, i�m trying to test Evermind�s Oracle DBCP. I�ll see if the same happen.
> ---------- > De: Galbayar[SMTP:[EMAIL PROTECTED] > Responder: Tomcat Users List > Enviada: ter�a-feira, 11 de novembro de 2003 3:31 > Para: Tomcat Users List > Assunto: RE: DBCP could not obtain an idle db connection, pool > exhausted > > > 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] >
