*
The moose likes Servlets and the fly likes Tomcat Database Connection Issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "Tomcat Database Connection Issue" Watch "Tomcat Database Connection Issue" New topic
Author

Tomcat Database Connection Issue

Todd Plambeck
Greenhorn

Joined: Jan 27, 2005
Posts: 10
I'm running an app on Tomcat 4.1 and having some database issues. If my DB server goes down and comes back up, the app in Tomcat crashes and can't reconnect to the database. Is this expected behaviour? Any insight on what's going on and a fix/work around would be greatly appreciated.

Thanks,

Todd
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42031
    
  64
An app crashing is certainly not expected behavior. Database connections can become stale even without the server going down, so the app should allow for that, and gracefully recover by re-connecting to the DB. A database connection pool can greatly help in this regard.


Ping & DNS - my free Android networking tools app
 
GeeCON Prague 2014
 
subject: Tomcat Database Connection Issue