Win a copy of Spring Boot in Practice this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Restoring a database connection after network failure

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Rancher
Posts: 2759
32
Eclipse IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic