SQLRecoverableException：I / O异常：连接重置 [英] SQLRecoverableException: I/O Exception: Connection reset

问题描述

昨天晚上，我离开办公室时，正在运行一个由我编写的Java程序。它应该使用JDBC连接将大量记录插入到我们的公司数据库（Oracle）中。今天早上当我回来工作时，我看到了这个错误（由try-catch捕获）：

Yesterday evening I left the office with a running Java program written by me. It should insert a lot of records into our company database (Oracle) using a JDBC connection. This morning when I came back to work I saw this error (caught by a try-catch):

java.sql.SQLRecoverableException: I/O Exception: Connection reset

程序在遇到此问题之前写了几乎所有记录，但是如果它发生得很早（我晚上离开办公室几分钟后）？我无法理解发生了什么，我联系了我的数据库管理员，他说数据库上没有特别的问题。

The program wrote almost all records before getting this problem, but what if it happens early (just minutes after I leave the office at evening)? I cannot understand what happened, I contacted my database admin and he said there was no particular issue on the database.

对发生的事情有什么想法，我该怎么做避免它？

Any idea on what happened and what can I do do to avoid it?

推荐答案

这只是意味着后端（DBMS）中的某些东西由于资源不可用而决定停止工作。
它与您的代码或插入数量无关。
您可以在此处阅读有关类似问题的更多信息：

This simply means that something in the backend ( DBMS ) decided to stop working due to unavailability of resources etc. It has nothing to do with your code or the number of inserts. You can read more about similar problems here:

• http://kr.forums.oracle.com/forums/thread.jspa?threadID=941911


• http://forums.oracle.com/forums/thread .jspa？messageID = 3800354

• http://kr.forums.oracle.com/forums/thread.jspa?threadID=941911
• http://forums.oracle.com/forums/thread.jspa?messageID=3800354

这可能无法解答您的问题，但您会明白为什么会这样正在发生。您可以与您的DBA进一步讨论，看看您的案例中是否有特定的内容。

This may not answer your question, but you will get an idea of why it might be happening. You could further discuss with your DBA and see if there is something specific in your case.

这篇关于SQLRecoverableException：I / O异常：连接重置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！