After getConnection(), do I need to always
test if the connection is stale? like do a dummy Select on a table and see if it does not throw an Exception?
Before returning the connection object to the caller, do I need to do this? check if stale?
If this is needed, is there a better way to check if stale? ..as this method means we will do an extra sql query, and can be a performance issue.
(My production server is Websphere 5.x (not sure on the x).)