Mysql数据库出现如下异常

[westwin]

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:110)
at java.io.DataOutputStream.write(DataOutputStream.java:85)
at org.gjt.mm.mysql.MysqlIO.send(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
at com.ocamar.nms.TrapThread.trapv1process(TrapThread.java:200)
at com.ocamar.nms.TrapThread$1.run(TrapThread.java:66)
at java.lang.Thread.run(Thread.java:534)
java.sql.SQLException: Communication link failure: java.net.SocketException
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
at com.ocamar.nms.TrapThread.trapv1process(TrapThread.java:200)
at com.ocamar.nms.TrapThread$1.run(TrapThread.java:66)
at java.lang.Thread.run(Thread.java:534)
java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:110)
at java.io.DataOutputStream.write(DataOutputStream.java:85)
at org.gjt.mm.mysql.MysqlIO.send(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.execute(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
at com.ocamar.nms.TrapThread.trapv1process(TrapThread.java:286)
at com.ocamar.nms.TrapThread$1.run(TrapThread.java:66)
at java.lang.Thread.run(Thread.java:534)
java.sql.SQLException: Communication link failure: java.net.SocketException
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.execute(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
at com.ocamar.nms.TrapThread.trapv1process(TrapThread.java:286)
at com.ocamar.nms.TrapThread$1.run(TrapThread.java:66)
at java.lang.Thread.run(Thread.java:534)


btw:数据库连接是通过自己的连接池返回的,可能在查询时出现如上的异常,google里也没找到什么办法

[tiger_wkh52741]

应该是你哪里连接数据库失败或者相关程序代码出错了！
仔细看看你的出错信息，有些地方告诉你详细的文件和代码行数，
你应该再仔细查查！

[westwin]

研究了一下,估计是:Connection连接超时,Connection很长时间没有使用,所以Mysql自动关闭
连接.