4
回答
Druid discard connection问题
华为云4核8G,高性能云服务器,免费试用   

@wenshao 你好,想跟你请教个问题:@wenshao 你好,想跟你请教个问题:

我在项目中使用了Druid连接池,版本:1.0.9,数据库:mysql,应用中会出现以下异常:

2014-11-06 22:36:28,537 ERROR [com.alibaba.druid.pool.DruidDataSource] - discard connection
com.mysql.jdbc.CommunicationsException: The last communications with the server was 28816 seconds ago, which  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.

配置了testWhileIdle=true,validationQuery=SELECT 'x'

timeBetweenEvictionRunsMillis=60000

minEvictableIdleTimeMillis=300000

举报
Kerwindu
发帖于4年前 4回/3K+阅
顶部