2

I am trying to insert the tens of millions of data into oracle database by through java application but after 850k data inserted I am getting the error:

java.sql.exception: IO Exception :Connection reset by peer socket write error.

Improve this question
2
  • 1
    It means that you had already been closed connection before you try flush or close connection. Commented Oct 11, 2012 at 8:06
  • 1
    NO, I opened only one connection , i close the connection until unless the process completed. Commented Oct 11, 2012 at 9:20

1 Answer 1

Reset to default
2

I have a similar issue in my aplication.

In my case, after a few minutes in which the connection has not used, oracle server resets the connection and when I had to use it again, this exception was thrown.

I found that the problem was that oracle sets the timeout for connection at 10 minutes in sqlora.net file.

Maybe you can try to increase this time interval or check if the connection is still valid instead to check if it is closed (a connection can be not valid even if it is not closed).

The last option works fine for me.

I hope this helps.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

which property was setting connection timeout to 10mins

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.