On Wed, Aug 27, 2003 at 02:19:09AM -0400, Dave Tilley wrote: > > Howdy, > > I've been having trouble getting Connection Pooling working with > either C3P0 or DBCP and using MySQL... the connection dies after some > number of hours and the next time the webapp is used, it hangs, and an > ioException is logged with a connection failure. > > I have been told there is some type of 'connection validation' that is > configurable and now i have learned that it is required in order to make > pooled connections work and not fail when the db/driver times out.
You can pass autoReconnect=true in the JDBC URL which makes the MySQL-driver attempt to reconnect if the connection dies. See: http://www.mysql.com/documentation/connector-j/index.html#id2800782 /Ludde
pgp00000.pgp
Description: PGP signature
