mysql超时设置问题

参考波子汽水yeah的博客，网址：https://blog.csdn.net/maobois/article/details/47292371

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 172,799,237 milliseconds ago.  The last packet sent successfully to the server was 172,799,238 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.

此为Mysql超时设置的问题，如果连接闲置8小时， mysql就会自动断开连接,，需要重启tomcat服务器。

解决办法：

一种. 如果不用hibernate的话, 则在　connection url中加参数: autoReconnect=true

jdbc.url=jdbc:mysql://xx:3306/database?autoReconnect=true&autoReconnectForPools=true

二种。用hibernate的话, 加如下属性:

<property name="connection.autoReconnect">true</property>

<property name="connection.autoReconnectForPools">true</property>

<property name="connection.is-connection-validation-required">true</property>

三。要是还用c3p0连接池:

<property name="hibernate.c3p0.acquire_increment">1</property>

<property name="hibernate.c3p0.idle_test_period">0</property>

<property name="hibernate.c3p0.timeout">0</property>

<property name="hibernate.c3p0.validate">true</property>