描述：
用jpa（hibernate實(shí)現(xiàn)）做應(yīng)用時，程序中報以下錯誤：
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.
解釋及解決辦法：
:<v?n
J:h"5~
如果連接閑置8小時 (8小時內(nèi)沒有進(jìn)行數(shù)據(jù)庫操作), mysql就會自動斷開連接, 得刷新應(yīng)用才行. 7
Wx_z
不用hibernate的話, connection url加參數(shù): autoReconnect=true $rJn[ZZpb
用hibernate的話, 加如下屬性: 'P 67p
<property name="connection.autoReconnect">true</property> dU%nxy0i+
<property name="connection.autoReconnectForPools">true</property>
;d]OEd ?"
<property name="connection.is-connection-validation-required">true</property> 0KjPAR6O
要是還用c3p0連接池: VxMBF,
<property name="hibernate.c3p0.acquire_increment">1</property> ;>RS{0\bfB
<property name="hibernate.c3p0.idle_test_period">0</property>
$?P?8pt'@
<property name="hibernate.c3p0.timeout">0</property> ,F:pe[
<property name="hibernate.c3p0.validate">true</property>