You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jacob Kjome <ho...@visi.com> on 2002/12/12 06:23:23 UTC
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>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
Jake
At 02:54 AM 12/12/2002 +0000, 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
Posted by Jacob Kjome <ho...@visi.com>.
At 05:55 AM 12/12/2002 +0000, 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 <ho...@visi.com> 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 +0000, 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
Posted by Leo Przybylski <le...@engr.arizona.edu>.
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>
> <name>url</name>
> <value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
> </parameter>
>
> Jake
>
> At 02:54 AM 12/12/2002 +0000, 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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: DBCP could not obtain an idle db connection, pool exhausted
Posted by Stephen Riek <st...@yahoo.co.uk>.
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 <ho...@visi.com> 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 +0000, 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