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]>
