[ajug-members] Web Application running on Tomcat hangs while connecting to DB

[hsaid at checkfree.com]

Members,
Here is the scenario:
- The web application running on Tomcat makes a connection to the datbase 
and waits for the response
- The processes on the Database max out so the Database node hangs
- The application goes into the hang mode waiting for the response from 
the application.

My question is : Is there a setting in Tomcat that would timeout the 
application if the response packet from the application does come back 
within a specified range? I know there is something one can do at the os 
level for example for windows by change the TCP_Wait time by changing the 
registry, similarly for Solaris. Is this the only solution that is at the 
OS level that can be applied, or Tomcat has some setting that can timeout 
the connection if the response is taking too much time? 

Note: Not considering implementing any change at the code level though


Thanks a bunch,
Hammad