Re: java.net.SocketException: Connection reset by peer: socket

Markus Wollny wrote:
> It seems
> that somewhere along the line, the Application Server just looses the
> connection to the database after about 2h17min total runtime of the
> batch.

> java.net.SocketException: Connection reset by peer: socket write error
> at java.net.SocketOutputStream.socketWrite0(Native Method)

Check for firewalls between the appserver and the database server. The
error is a TCP-level connection error that means that the peer (the
database server) unexpectedly disappeared on us, and we didn't see an
orderly shutdown of the connection. If it always happens after a certain
connection length, or after the connection has been idle for a certain
period, it's likely that there is a stateful firewall in the way that is
dropping the connection after that period.

Failing that, does the database side log anything about the disconnection?

-O