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 or do I have to check for status?
Nix.