• Post Reply Bookmark Topic Watch Topic
  • New Topic

Reconnecting to the Database  RSS feed

Ian Morris
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.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!