mysql超时失效c3p0_c3p0 mysql数据库连接池 8小时连接失效

mysql 8 小时默认就断开了不适用的连接。但是c3p0  默认 连接是不断开的。所以就会8小时后不访问项目的话，第一次登陆汇报一下异常。

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

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

参考文档：

最后贴出我的配置

SELECT 1

#When not using JMX, eliminate many times load c3p0 warnings

com.mchange.v2.c3p0.management.ManagementCoordinator=com.mchange.v2.c3p0.management.NullManagementCoordinator

c3p0.pool.size.max=20

c3p0.pool.size.min=10

c3p0.pool.size.ini=5

c3p0.pool.size.increment=3

c3p0.pool.testConnectionOnCheckin=true

#c3p0.pool.automaticTestTable=c3p0automaticTestTable

c3p0.pool.idleConnectionTestPeriod=1800

c3p0.pool.maxIdleTime=25000