You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2002/04/30 14:12:04 UTC

DO NOT REPLY [Bug 8644] - Mysql-Connection (Servlet) Problem (Timeout ?)

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8644>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8644

Mysql-Connection (Servlet) Problem (Timeout ?)

glenn@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID



------- Additional Comments From glenn@apache.org  2002-04-30 12:12 -------
I looked at your code. This is not a bug in Tomcat, it is a problem in
your servlet.  MySQL has a limit for how long it will keep an idle db
connection open, the default is 8 hours.  Your code never tries to reopen
the db connection if it gets closed from the db side.  You might consider
using a db connection pool instead of your own code for managing db connections.
For further assistance please use the tomcat-user list.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>