PreparedStatementCallback;
SQL [delete from highpricehis where createdate = ?];
The last packet successfully received from the server was 18,841,762 milliseconds ago. The last packet sent successfully to the server was 18,841,763 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.;
nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
也就是说5个小时以前,客户端想服务器端发送了最后一个数据包,但是mysql服务器端的超时时间设置为4个小时,也就是说这个连接在服务器端进行了断开,但连接池中并没发下这个链接被断开,导致使用了一个已经断开的连接,导致抛出异常
一个解决办法是设置数据的连接的长度为8小时。