Hi Varma:
Make sure that after *every* try/catch block where you create a Statement and/or
a ResultSet, you add the following code in a finally block (i.e. reagrdless of
whether or not the Statement/ResultSet creation was a success:
finally{
try{
rs.close();
stmt.close();
}catch( etc..
}
We had a problem similar to what you describe and found that this was the
problem.. If this does not solve the problem, try to see where *exactly* you
start hanging by inserting println statements after each statement in your code
and/or using the Exception.printStackTrace() method (the latter gives the exact
line number where the servlet engine runs into trouble if you wait long enough
so your servlet times out...)
Good luck!
Geeta
Srinivasa Mantena wrote:
> Following is our configuration
>
> Java Servlet Engine -> Tomcat 3.5
> Platform: SunOS 5.6
> JDBC Driver: Oracle JDBC Driver(classes12.zip)
> Oracle Version:
> Java Version: Solaris VM (build Solaris_JDK_1.2.1_04, native threads,
> sunwjit)
>
> It is having a miscellaneous problem. It works fine for a couple of days
> and sometimes only
> a couple of minutes and it starts hanging. I mean no response at all for
> servlets/html's.
> I need to restart Tomcat Server everytime it happens.
>
> I already attempted the following to debug the problem, but no use
>
> * Checked if it the system reached maximum number of Database connection and
> it is not.
> * Changed the Servlet Engine. Earlier it was JRUN and now it is Tomcat
>
> Please let me know if any ideas to fix this problem
>
> Thank you in advance
> Varma
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> ___________________________________________________________________________
> 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
___________________________________________________________________________
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
