Hi Ralph, Thanks for your reply first.
>>If there is no error message in the logs, I guess >>it's a deadlock in the database. Reply: The thing that I do not understand is why do you think it could be a deadlock in DB because I just restart TomCat but not Oracle, the TomCat can talk to Oracle (test from login screen where it actually reads table from Oracle)? >>Can you provide more info about the jsp that hangs ? Reply: When the problem happens, all the pages that will access to Oracle DB can not work, for example the login screen page which read from table in Oracle. However, other JSP pages that do not access Oracle can be executed. >>Try a kill -QUIT <tomcat pid> and have a look at the >>stacktrace to see where the threads are. Reply: I will try it out when it happens again. >>Have a look at the oracle console (can't remember the name >>of the management console for oracle, it's too long ago >>that I used it) to find out which connections and statements >>are open. Reply: Oracle console - if you are saying Oracle Enterprise Manager, actually it is not implemented. Any other alternative? Thanks. ----- Original Message ----- From: "Ralph Einfeldt" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 7:08 PM Subject: AW: TomCat 3.2.3 not respond suddenly. If there is no error message in the logs, I guess it's a deadlock in the database. Can you provide more info about the jsp that hangs ? Try a kill -QUIT <tomcat pid> and have a look at the stacktrace to see where the threads are. Have a look at the oracle console (can't remember the name of the management console for oracle, it's too long ago that I used it) to find out which connections and statements are open. > -----Ursprüngliche Nachricht----- > Von: TEOH KANG YIH [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 2. Juli 2002 12:53 > An: [EMAIL PROTECTED] > Betreff: Re: TomCat 3.2.3 not respond suddenly. > > Remember I post this question 1 week ago and there is no > feedback from you all? However, I have found out further > information as follows: > > 1. Port 8080 still can be telneted in > 2. Other JSP files still can be accessed > > These 2 important tell us that TomCat is still > functioning! Only it can't talk to Oracle Database, until I > restart TomCat. > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>