David,
I was having the same problem.
autoReconnect=true does not work because it has been deprecated.
Timeout is due to default setting of 'interactive_timeout' and 'wait_timeout'
properties in config file (my.ini) under MySql server, which is 28800 secs or 8
hours.
I have put the follo
Also be aware that autoReconnect=true only works (according to the mysql
docs) for Connections with autocommit set to true.
If you are using a connection pool make sure it checks the validity of
Connections every so often. This is configurable for DBCP:
http://jakarta.apache.org/commons/dbcp/c
This is an interesting problem. But first try setting
autoReconnect=true in your connections string.
If you continue to experience a timeout.. Check the logs, and see
what specifically is happening. You may be experiencing an
exhaustion of connections not being released properly.
If
--- "David W. Brown" <[EMAIL PROTECTED]> wrote:
> Hello TC dev and Gurus, I have a webapp comprised of
> several Servlets and JSP pages. The webapp is
> functioning very well but after a few hours of no
> connections or interaction the TC webapp loses its
> connection with the MySQL DB. We are usi
