1. 爱易网页
  2. Java教程
  3. java.sql.SQLException: I/O Error: Connection resetCaused by: java.net.SocketExce解决方案

java.sql.SQLException: I/O Error: Connection resetCaused by: java.net.SocketExce解决方案

日期：2014-05-20　 浏览次数：20665 次

java.sql.SQLException: I/O Error: Connection resetCaused by: java.net.SocketExce
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1052)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301)
at com.demo.test.Sqlserver_To_Mysql.getTableData(Sqlserver_To_Mysql.java:364)
at com.demo.test.Sqlserver_To_Mysql.main(Sqlserver_To_Mysql.java:113)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:841)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:722)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3928)
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1045)
... 4 more

------解决方案--------------------
lz把连接关了
------解决方案--------------------
楼上正解 楼主把Connection关了，之后再次调用了该对象..

相关资料更多>

  1. 找到bean的原因大家帮小弟我看一下
  2. 测试setAutoCommit(false)跟executeBatch()发现setAutoCommit(false)没起作用！
  3. org.apache.commons.dbcp.SQLNestedException
  4. mysql 中Datetime数据类型有关问题
  5. 一个连接数据库的Bean程序为什么在每一个set方法里面都要声明StringBuffer类型的变量?该怎么处理
  6. servlet打印页面的所有超级链接,该如何解决
  7. 吐血推荐一个2G的 个人网络硬盘解决思路
  8. Java面试标题系列五
  9. 新年马上到了,散点分.祝java 朋友新的一年,宏图大展,心想事成!该如何处理