com.mysql.jdbc.exceptions.jdbc4.CommunicationsException||java.net.SocketException: Broken pipe

原创于 2014-07-01 09:19:24 发布 · 452 阅读

0 ·

CC 4.0 BY-SA版权

MySql 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了在使用JPA（Hibernate实现）过程中遇到的MySQL超时错误，并提供了详细的解决步骤，包括调整MySQL配置文件来增加连接等待时间。

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

描述：

    用jpa（hibernate实现）做应用时，程序中报以下错误：
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
    The last packet successfully received from the server was 79,221,885 milliseconds ago.
    The last packet sent successfully to the server was 79,221,885 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.

解释及解决办法：

//设置时间

set global wait_timeout=1814400;

//显示时间

show global variables like 'wait_timeout'

如果直接改文件的话

vim /etc/my.cnf

[mysqld]

wait_timeout=1814400

interactive_timeout=1814400