commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dennis Muhlestein <den...@zserve.com>
Subject Re: jdbcpool
Date Wed, 05 Jun 2002 15:45:57 GMT
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:commons-dev-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>
> 
> -- 
> ----------------------------------------------------------------------
> Glenn Nielsen             glenn@more.net | /* Spelin donut madder    |
> MOREnet System Programming               |  * if iz ina coment.      |
> Missouri Research and Education Network  |  */                       |
> ----------------------------------------------------------------------
> 
> --
> To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>
> 



--
To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>


Mime
View raw message