• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reconnecting to the Database

 
Ian Morris
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a couple of web based Java applications that access databases, one uses Oracle (oci drivers) and one MS SQL Server 2000 (odbc). I use Jakarta-tomecat-3.2.1 along with JSP and servlets.
My question is, is there a way to reconnect to the datbase automatically if, for example there is a network outage, I always have to re-start the Jakarta service (I assume this is because my database connections are setup in the init of a servlet, maybe this is wrong?).
Does database connection pooling avoid this? Should I be doing something else? Any advise is appreciated.
Ian.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic