What I was thinking about is something like
Thread 1: lock resource A
(Resource can be a certain row in the database)
Thread 2: lock resource B
Thread 2: lock resource A - Waiting for Thread 1
Thread 1: lock resource B - Waiting for Thread 2
-- Deadlock
If you kill tomcat all lock are
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