Thanks for the reply, I had found the autoReconnect parameter and that seeme to solve my problem. I heard there is an over head associated with that though but I don't believe it to be a problem for me at this time.
On Tue, 2002-06-04 at 22:22, Glenn Nielsen wrote: > If your are using the mm.mysql JDBC driver add the autoReconnect=true > arg to your mysql connect url. With this the mysql jdbc driver will > reconnect to the db if it looses the connection. > > Then you can set your minIdle to 1, and your mysql db can timeout > its connection after the default 8 hours. But that one idle connection > in dbcp can reconnect if needed. > > Regards, > > Glenn > > Dennis Muhlestein wrote: > > > > I'm using the commons-pool, commons-dbcp to connect to mysql from tomcat > > 4. Everything works fine when I develop but if I leave the site > > unattened for a period of time, mysql times out the connections in the > > pool. > > > > I'd really like to set the maxIdle parameter to 0 so that if there are > > idle connections they leave the pool. Basically setting the min pool > > size to 0 is what I want to do. I haven't seen a minPoolSize parameter > > though. > > > > The documentation says if I set maxIdle to 0 that means unlimited. That > > won't work I guess. Is there a solution to this problem? > > > > Thanks > > Dennis > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- > ---------------------------------------------------------------------- > Glenn Nielsen [EMAIL PROTECTED] | /* Spelin donut madder | > MOREnet System Programming | * if iz ina coment. | > Missouri Research and Education Network | */ | > ---------------------------------------------------------------------- > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>