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.
0
