wait_timeout=99
You can change the timeout values as you may want. Above values are max. values.
Rajiv
-Original Message-
From: David W. Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 1:51 PM
To: users@tomcat.apache.org
Subject: JDBC/MySQL user login goes stal
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
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 usin
