Hi Apurva!
Same used to happen to me. If you are using MySQL, and you open the
connection to the DB in the init() method in the servlet, it happens that
after 8 hours (default), Mysql shutdowns any connection from which it does
not receive any kind of request. I solved it using a connection parameter of
mm.mysql 2.0.4 (I recomend upgrading yours), that makes automatic
reconnection if it detects that the connection died. It works (at least for
me ;-) ) Browse mm.mysql documentation for more details, but this can help
you right now:
Connection conn =
DriverManager.getConnection("jdbc:mysql:<DB_Url>?autoReconnect=true", user,
password);
Cheers,
Luis ;-)
----
Luis G. López
ICQ# 99032359
http://www.geocities.com/luisglopez (Última actualización: 2/4/2001)
Original mail:
Date: Fri, 6 Apr 2001 05:16:59 -0000
From: Apurva KiritKumar Shah <[EMAIL PROTECTED]>
Subject: Servlet stops to respond
Respected Friends
I am in great trouble.
Friends I have redhat linux 6.1,with tomcat-3.2.1,mysql-3.23.32 and
mm.mysql.jdbc 1.2c driver,apache 1.3.9 .I have a site named
lucky-tickets.com .On which i am using servlet with applet.Now my servlet is
for authentication and user registratrion .My servlet are sunning fine for
whole one day,and another day it suddenly stop to responding .I don't what
happens.but it shows nothing,no exception ,nothing else only white page.Than
i restart tomcat and it runs fine for another one day.I have put nothing in
web.xml except some necessary lines.No servlet named specify in web.xml
.Please help me to solve this problem.I know this is not a bug from your
side ,but no body give me solution regarding this.
When servlet related to this site stops another servlet of other site
responds.I read the error log of mysql.There was a request time out for the
database this site uses.
Please help me!
Thank You
Regards
Apurva shah
___________________________________________________________________________
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
