mysql+c3p0+慢_C3P0连接池+MySQL的配置及wait_timeout问题的解决方法

在一个晚上没有连接访问接口的情况下，第二天清晨再访问接口，第一次会报数据库连接错误。解决办法是在c3p0配置中添加如下属性：

报错日志如下 ：​

​

### Error querying database.  Cause:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last

packet successfully received from the server was 87,501,327

milliseconds ago.  The last packet sent

successfully to the server was 87,501,359 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.

### The error may exist in file

[/data/formax_data/soft/tomcat-7.0.75/webapps/ROOT/WEB-INF/classes/sql/consumerDashboard.xml]

### The error may involve

com.formax.app.dao.ConsumerDao.getSparkResultData-Inline

### The error occurred while setting parameters

### SQL: select

prdCode,contractNo,customerId,accountNo,ip,accountCountByDeviceNo,accountSetByDeviceNo,accountCountByStationIp,accountSetByStationIp

,relativeDeviceSetByCustomerId,relativeCustomerAccSetByCustomerId,failLoginCountIn5Mins,loginmMaxdistance,contactNum,contactList

,timeDifferenceBetweenWithdrawalAndAddBankCard,devicesListLastThree,timeDifferenceBetweenWithdrawalAndUpdatePassword,contactPhone

,todayLivingCheckFailNum,historyLivingCheckFailNum,todayLivingCompareFailNum,historyLivingCompareFailNum,fillPhoneStartTime,fillPhoneEndTime

,fillSalaryStartTime,fillSalaryEndTime,fillAddStartTime,fillAddEndTime,scanIDStartTime,scanIDEndTime,scanIDNum,scanCardStartTime,scanCardEndT