Hi all - Connections should really have an isValid() method, eh?
> Ok, so it's indeed broken. The thing is that there's no way to know if the > JDBC exception you get indicates that the connection is broken, > that the SQL is bad, or something else :-( In my company's software, a connection is checked every Xth time it is released to the connection pool by performing some sort of NOOP, like "select 1 from dual" in the case of Oracle. If this throws an exception, then we mark the connection as down. An improved heuristic would then mark all other connections in the pool for immediate checking. I don't know if that would work in your context, but good luck!
smime.p7s
Description: application/pkcs7-signature
