数据库断开连接

木土

MySQL数据库断开连接
The last packet successfully received from the server was 594,881 milliseconds ago.  The last packet sent successfully to the server was 594,902 milliseconds ago.
已经在tomcat的配置中增加mysql中validationQuery=”select current_date”或者validationQuery=” select current_time”


现在出现新的问题
Sat Oct 13 10:27:55 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

wsh

ssl的问题，可禁用，jdbc连接这样
jdbc:mysql://mysql:3306/dbname?useSSL=false&requireSSL=false

木土

这个是写在Tomcat的context.xml配置文件中的吗

jishuang

配置数据源的时候url直接这样写就可以，或者自己到Tomcat的context.xml配置文件中修改