RE: DBCP could not obtain an idle db connection, pool exhausted
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value20/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valueusername/value /parameter parameter namepassword/name valuepassword/value /parameter parameter namedriverClassName/name valueocom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc: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]
RE: DBCP could not obtain an idle db connection, pool exhausted
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value20/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valueusername/value /parameter parameter namepassword/name valuepassword/value /parameter parameter namedriverClassName/name valueocom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc: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]
RE: DBCP could not obtain an idle db connection, pool exhausted
Hi buddy, I also have same problem with same configuration with j2sdk-1_4_1_02. I close ResultSet, Statement and Connection afer use but after 3, 4 times continuous connection, server connection fail during transaction message appear. When I restart Tomcat, it works again. Than Win Project Manager Raynet IT Co.Ltd Myanmar 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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value20/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valueusername/value /parameter parameter namepassword/name valuepassword/value /parameter parameter namedriverClassName/name valueocom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc: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]
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value20/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valueusername/value /parameter parameter namepassword/name valuepassword/value /parameter parameter namedriverClassName/name valueocom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc: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]
Re: DBCP could not obtain an idle db connection, pool exhausted
Hello, I don't know if my issue is much related to yours, but let me enlighten you with some results I have found from testing. I used tomcat 4.1.12 with mysql 3.x and jdk1.3.1_03(06). I found that when i set my idle connection count low in my server.xml I would get DBCP Driver : null (something like that) errors. The odd thing I found is that it should only do that when the mysql server is denying connections (the maximum allowable connections to the server has been reached). This is strange because that when I set my connection count to 40 and mysql is configured to allow 100 connections, I find only 12 actual connections are made to mysql. When I raise the idle connections to unlimited, it seems that a large majority of my connections that are used are idle connections. Only 2 or 3 actual connections are ever made to the mysql database server itself. I also find myself getting the same errors that you are even those I have it configured for unlimited idle connections and only a couple actual connections are made to the database. Do you find this to be accurate also? -Leo On Wed, 2002-12-11 at 19:54, Stephen Riek wrote: Just wondering how I could have ended up getting DBCP could not obtain an idle db connection, pool exhausted errors ? I've stopped sending requests to the server but the problem persists and it looks like I'll have to restart Tomcat.Surprised that the pool didn't automatically reclaim connections. Thanks, Stephen. - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DBCP could not obtain an idle db connection, pool exhausted
I use MySQL as well with ?autoReconnect=true, but I have been getting this same error for awhile now. -Leo On Wed, 2002-12-11 at 22:23, Jacob Kjome wrote: By chance are you using MySQL? Then add ?autoReconnect=true to your url parameter like this parameter nameurl/name valuejdbc:mysql://localhost:3306/javatest?autoReconnect=true/value /parameter Jake At 02:54 AM 12/12/2002 +, you wrote: Just wondering how I could have ended up getting DBCP could not obtain an idle db connection, pool exhausted errors ? I've stopped sending requests to the server but the problem persists and it looks like I'll have to restart Tomcat.Surprised that the pool didn't automatically reclaim connections. Thanks, Stephen. - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DBCP could not obtain an idle db connection, pool exhausted
By chance are you using MySQL? Then add ?autoReconnect=true to your url parameter like this parameter nameurl/name valuejdbc:mysql://localhost:3306/javatest?autoReconnect=true/value /parameter Jake At 02:54 AM 12/12/2002 +, you wrote: Just wondering how I could have ended up getting DBCP could not obtain an idle db connection, pool exhausted errors ? I've stopped sending requests to the server but the problem persists and it looks like I'll have to restart Tomcat.Surprised that the pool didn't automatically reclaim connections. Thanks, Stephen. - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
Re: DBCP could not obtain an idle db connection, pool exhausted
I am indeed Jacob, are you psychic ? Thanks, I'll try the autoReconnect and am sure it'll work - you've obviously come across this before. Stephen. Jacob Kjome [EMAIL PROTECTED] wrote: By chance are you using MySQL? Then add ?autoReconnect=true to your url parameter like this url jdbc:mysql://localhost:3306/javatest?autoReconnect=true Jake At 02:54 AM 12/12/2002 +, you wrote: Just wondering how I could have ended up getting DBCP could not obtain an idle db connection, pool exhausted errors ? I've stopped sending requests to the server but the problem persists and it looks like I'll have to restart Tomcat.Surprised that the pool didn't automatically reclaim connections. Thanks, Stephen. - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
Re: DBCP could not obtain an idle db connection, pool exhausted
At 05:55 AM 12/12/2002 +, you wrote: I am indeed Jacob, are you psychic ? Yes, but please refrain from nominating me for the biggest douche bag in the universe award. NOTE: If you do not watch South Park or didn't see the episode featuring John Edwards, you can ignore the previous comment or read this synopsis: http://www.tvtome.com/tvtome/servlet/GuidePageServlet/showid-344/epid-213373/ :-) Jake Thanks, I'll try the autoReconnect and am sure it'll work - you've obviously come across this before. Stephen. Jacob Kjome [EMAIL PROTECTED] wrote: By chance are you using MySQL? Then add ?autoReconnect=true to your url parameter like this url jdbc:mysql://localhost:3306/javatest?autoReconnect=true Jake At 02:54 AM 12/12/2002 +, you wrote: Just wondering how I could have ended up getting DBCP could not obtain an idle db connection, pool exhausted errors ? I've stopped sending requests to the server but the problem persists and it looks like I'll have to restart Tomcat.Surprised that the pool didn't automatically reclaim connections. Thanks, Stephen. - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs - With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
