• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Restoring a database connection after network failure

 
Pavel Vosahlo
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guis,
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.

Configuration:
DB Informix, version 11.7, access via csm
Application server JBoss 0.7.1.1 Final
Informix JDBC driver 4.10.2

Any idea, experience or solution welcome …

VosaPa
 
Jayesh A Lalwani
Rancher
Posts: 2762
32
Eclipse IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic