You could execute some simple SQL and catch any exceptions to test the
connection and re-establish it if necessary. There's also an isClosed()
method of Connection which the docs say will test to see if a connection
is closed.
Theres some stuff in javax.sql (jdbc extensions) that provide
Connecti
Instead of checking if the Connection is null, why not try a simple test of
whether
the connection is still active.
Try a query: "select USER from dual" for instance, if an exception is thrown
this
indicates the connection is invalid and needs to be reset.
You might also like to take a look at t
Hi all,
I'm having a problem with a jdbc connection object between tomcat and an
oracle server. The 2 machines are separated by a firewall which was
configured to allow access to the oracle server from the tomcat server only.
The problem starts when the timeout period(which can be set to an arbitr