I'm not sure whether this is the correct forum to post this question, since the technologies involve Oracle, Java, as well as networking. Please let me know if you think I should post this question elsewhere.
Recently, we started receiving the following error in our log file:
java.sql.SQLException: Io exception: Connection reset by peer: Connection reset by peer
Io exception: Broken pipe
We have been running the application successfully for several weeks with no occurrences of this error. We also have several other applications, identical to the one in question, except for the fact that each of the other instances connect to different remote databases. Because these other instances are running correctly, and this one is not, I was under the impression that it was a problem at the remote database server side. I phoned the administrator over there, and they said a firewall had to be replaced, so I gave them our IP so that we could get through their firewall. However, the error appeared again last night (the application in question runs once every night).
The initial part of the application appears to be working correctly. Essentially, what we have at the remote end is a small PL/SQL program which waits for a trigger to tell it that new data has been inserted. After the program is notified, the data is sent to an Oracle pipe. At the local end, we have a small Java program which checks the pipe to see if any data is available in the Oracle pipe - if so, all the data is retrieved, and then the Java program enters a loop which checks the Oracle pipe for new data during each iteration of the loop, and retrieves any available data. The first part of the Java program appears to retrieve the initial data just fine. However, when the loop is started, the above error is received, and the loop is exited, terminating the Java program.
I still think something is wrong at the remote database end, but cannot pin down the problem. Any assistance in figuring out what is causing the above error message is much appreciated! I searched online for an explanation, and was not able to determine the problem.
I am assigning a high point value to this question since this is an urgent matter.