@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
我也想知道啊。。纠结。
不用线程池没发现问题,一用线程池发现了这么多问题。。网上有说手动 session.close(); ,但用的mytatis,也没有使用注解啥的,,怎么手动关闭??