"persistent" connection in a Servlet - Mailing list pgsql-jdbc

From Nikola Milutinovic
Subject "persistent" connection in a Servlet
Date
Msg-id 001801c18f86$d1ee2780$0a3ea8c0@ev.co.yu
Whole thread Raw
Responses Re: "persistent" connection in a Servlet  (Ned Wolpert <ned.wolpert@knowledgenet.com>)
List pgsql-jdbc
Hi all.

One question. Suppose I write a servlet which uses one JDBC connection, initializing it not per-request, but once it is
loaded.Similarly it closes the connection not after the request has been serviced, but only when the servlet is
unloaded.This means that JDBC connection will be opened and held open for a long time, with sporadic interactions. 

What happens if I shutdown the database, while JDBC connection is open and bring it up again? Will it try to reconnect
ordo I have to check for status? 

Nix.

pgsql-jdbc by date:

Previous
From: Peter Adamek
Date:
Subject: SOLVED: Problem with connecting to postgres using JDBC with JSP, but not JDBC with Java
Next
From: "Mihai Gheorghiu"
Date:
Subject: Re: Connection pooling