Meaningless Drivel is fun!
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

Tomcat Database Connection Issue

Todd Plambeck

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.


Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
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.
I agree. Here's the link:
subject: Tomcat Database Connection Issue
It's not a secret anymore!