mysql连接超时报错
The last packet successfully received from the server was 14,929 milliseconds ago. The last packet sent successfully to the server was 14,930 milliseconds ago.The last packet successfully received from the server was 14,929 milliseconds ago. The last packet sent successfully to the server was 14,930 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:520)
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:700)
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:639)
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:987)
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:666)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:930)
... 62 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
怎么延长这个时间呢 。。不知道配置啥属性，求大佬帮忙解答下
呐拿去
https://www.bmabk.com/index.php/post/106031.html
实际上就是 给 阿里巴巴的连接池增加一个 查询的sql让他定期去查一次数据库，这样你数据库连接最少就能有是存活状态，这样他就不会死了 你这不是超时，是长时间没连接，这条链接已经断掉了。实际按楼上给的方案，修改下Druid的配置让它自己定期清理下连接池里面的过期链接就行了 这个不是超时了,是长时间没有用mysql 连接被mysql服务器断开了
具体参考楼上 点击连接，设置最小时为5秒，次数不限 学习到了 参考楼上，比较好奇的是啥项目长时间没连接，自己能断掉？
页:
[1]