Reestablishing a db connection after a network failure

From: Pandis Ippokratis (ippokratis_at_cmu.edu)
Date: 04/29/04 

Date: 29 Apr 2004 05:15:22 -0700

Hi,

 I have the following problem: I am implementing a server in Java and
I use jdbc to connect to an Oracle 9.0.2 db. All seem to work fine,
but when I intensionally cause a network failure (i.e. I remove the
network cable) I get the following exception:

java.sql.SQLException: Io exception: Connection reset by peer: socket
write error

I plug the cable again and I want to reset the java.sql.Connection but
this seems to not work. Any suggestions?

Relevant Pages

  • Reestablishing a db connection after a network failure
    ... I use jdbc to connect to an Oracle 9.0.2 db. ... but when I intensionally cause a network failure (i.e. ... java.sql.SQLException: Io exception: Connection reset by peer: socket ...
    (comp.lang.java.programmer)
  • Re: Minimizing Connection reset by peer exceptions
    ... > Occasionally the following exception gets ... > (10054, 'Connection reset by peer') ... Such is life, when dealing with networking. ...
    (comp.lang.python)
  • Re: ftplib error- Large file
    ... Shouldn't ftplib return something like (104, ... "Connection reset by peer") instead of throwing an error? ... the connection was reset by peer. ... As it *was* an error, an exception is correct. ...
    (comp.lang.python)
  • Help:java.net.SocketException: Connection reset
    ... When I tried to read a HTML page using URLConnection I got the following ... Exception. ... I need help in solving this problem. ... java.net.SocketException: Connection reset ...
    (comp.lang.java.programmer)
  • Re: How to tell if an exception has been caught ( from inside the exception )?
    ... I'm writing an exception that will open a trouble ticket for certain events. ... Things like network failure. ... I thought I would like to have it only open a ticket if the exception is not caught. ...
    (comp.lang.python)