Hi there, I'm having some problems here: I open a connection to a
MySQL server in the init() method of a Servlet, and make queries by the
doGet() or doPost() method with no problems.
The problem is, passed some time (minutes, hours, I don't know), I
get a Broken Pipe or Closed Connection (SQLException). I guess that
connection has a life time or a timeout, and the only way to get it back
is by restarting the server.
What should I do? Is there anyplace to set this timeout, is there
a way to always keep the connection opened? Or should I open and close the
connection for every query (isn't it a little slow?) ??? Or maybe it's a
problem with the MySQL settings????
Appreciate any help, thanks!
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
