问题
discard long time none received connection. , jdbcUrl :
jdbc:mysql://ip:port/db_name?useUnicode=true&&useSSL=false&serverTimezone=Asia/Shanghai&allowMultiQueries=true
, version : 1.2.8, lastPacketReceivedIdleMillis : 357004 pos=DruidAbstractDataSource.java:1494
解决
- 方式1
use-ping-method: false
spring:
datasource:
dynamic:
primary: mysql
datasource:
mysql:
druid:
validation-query: SELECT 1
url: jdbc:mysql://ip:port/db_name?useUnicode=true&&useSSL=false&serverTimezone=Asia/Shanghai&allowMultiQueries=true
username: xxx
password: xxx
driver-class-name: com.mysql.cj.jdbc.Driver
use-ping-method: false
- 方式2
# 在运行参数中增加:-Ddruid.mysql.usePingMethod=false