We are trying to solve problem with DB connection recovery after TCP-IP link dropout.
When the DB connection (connected or connecting) isn’t used in time of network failure, then the AS knows how to remove the ‘old‘ connection a and establish the new one.
But quite different situation is when the DB connection is just executing – info about network failure doesn’t go through JDBC driver to AS and the DB connection remains blocked. This leads to total connection pool blocking with appropriate unpleasant application consequencies. The only solution is AS restart.
DB Informix, version 11.7, access via csm
Application server JBoss 0.7.1.1 Final
Informix JDBC driver 4.10.2
Usually, the JDBC driver handles this kind of situation. If there is a network connection failure, the JDBC driver issuppossed to detect it and throw an exception. Atleast all the JDBC drivers I have worked with will do that. I've never worked with Informix. Is this a known issue with Informix? Maybe Informix customer support might be able to help