File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: 42959
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.
subject: Tomcat Database Connection Issue
It's not a secret anymore!