springboot链接mysql长时间不访问后报错怎么办

[z896709283]

[maryciji]

mysql>show global variables like 'wait_timeout'; mysql>set global wait_timeout=604800;

[澜月]

试试在application.properties中设置datasource的时候，加入如下设置： (testWhileIdle,validationQuery,timeBetweenEvictionRunsMillis) dataSource.bySearch.testWhileIdle = true dataSource.bySearch.validationQuery=SELECT 1 dataSource.bySearch.timeBetweenEvictionRunsMillis = 3600000 每隔一小时向mysql进行一次连接可用确认

[laohuxiaotu]

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>

运行时在连接，不运行时就断开

[能源恒观]

线程池使用了吗，这么奇怪

[k10509806]

可以开启 spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL spring.datasource.druid.testWhileIdle=true 检测