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 it is a true timeout and autoReconnect does not solve it... try
writing a heart beat (1/hour) to test if this keeps it up and running.
Be cognizant of connections NOT being returned back to the pool by a
proper close. Which does not mean that you're not closing correctly
from your code, you maybe experiencing a close issue with JDBC. So,
the version of JDBC is certainly another item to check. :-)
Hope that helps!
jes
On Nov 29, 2005, at 2:21, David W. Brown 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 using the server.xml
defined JDBC/MySQL security model using the users and user_roles
tables DB structure. The logins work perfectly until a few hours of
(like overnight) in attendance. Even thought the TC Servlet server
is still up and running logins all fail. After restarting TC the
login mechanism works perfectly. Particulars follow. Please advise.
TC Servlet server 5.5.7
MySQL 4.1
OS Windows XP (whistler).
David Brown
IT/Systems
USM-I KBR-Central
APO AE 09316
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]