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

[Jack Coleman]

Have you considered using a transaction manager like JOTM?  That way you 
could control the timeout with the TM.

hsaid at checkfree.com wrote:
> 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
> _______________________________________________
> ajug-members mailing list
> ajug-members at ajug.org
> http://www.ajug.org/mailman/listinfo/ajug-members
>
>