com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

最新推荐文章于 2025-03-05 00:03:57 发布

晴思梦语

最新推荐文章于 2025-03-05 00:03:57 发布

阅读量2.1k

点赞数

分类专栏： mysql 文章标签： mysql the last packet successfully receiv milliseconds ago 数据库异常 com.mysql.jdbc.exceptions.jdbc

本文链接：https://blog.youkuaiyun.com/wdf521121/article/details/88814266

版权

在Tomcat8.5中，应用每隔一段时间出现com.mysql.jdbc.exceptions.jdbc4.CommunicationsException，原因是wait_timeout超过了服务器配置。通过修改MySQL配置文件my.ini，增加'wait_timeout=1814400'解决了此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 152,219,305 milliseconds ago.

数据库服务器：mysql5.0

应用服务器：tomcat8.5

出现问题：

应用发布后发现每过一段时间后tomcat就会报错。错误信息大概如下：

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 152,219,305 milliseconds ago. The last packet sent successfully to the server was 152,219,305 milliseconds ago. is longer than the server configured value of ‘wait_timeout’. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property ‘autoReconnect=true’ to avoid this problem.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

No operations allowed after connection closed.

java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:803)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6985)
at com.dz.servlet.LoginServlet.service(LoginServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11AprProcessor.

最低0.47元/天解锁文章