Question

Last packet sent to the server was 0 ms ago.

ERROR JDBCExceptionReporter:101 - Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Connection reset by peer: socket write error

STACKTRACE:

java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
16:00:00,197 ERROR JDBCExceptionReporter:101 - Already closed.
16:00:00,197 ERROR JDBCExceptionReporter:101 - Already closed.
16:00:00,200 ERROR JDBCExceptionReporter:101 - Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

长时间未操作，就会报该错；百度了许多，说是把wait_timeout改为10年，觉得这个方法不敢恭维；
autoReconnect=true，不起作用；求解！！！

Answer 1

Connection reset by peer: socket write error 连接被重置，socket 写入错误

odbc的错误 应该就是数据库的原因了 请规范数据库操作
每次打开就要记得关掉

追问

不是哦，是连接超时，mysql的默认连接是8小时，过了8小时就会报这个错。。。

追答

没错啊 就是因为你的连接一直开着~~~需要读取或者写入再去打开数据库

Answer 2

看看是不是端口的问题。我在项目启动遇到同样问题。原来在项目中配置URL时没有写端口，而启动端口由3306变成3307，导致错误。

Answer 3

ERROR JDBCExceptionReporter:101 - Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Connection reset by peer: socket write error

STACKTRACE:

java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
16:00:00,197 ERROR JDBCExceptionReporter:101 - Already closed.
16:00:00,197 ERROR JDBCExceptionReporter:101 - Already closed.
16:00:00,200 ERROR JDBCExceptionReporter:101 - Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **