需要使用高版本的JDBC驱动,“mysql-connector-java 8”以上版本。

1.JDBC driver 由“com.mysql.jdbc.Driver”改为“com.mysql.cj.jdbc.Driver”。

2.JDBC url为:jdbc:mysql://localhost/rs_report?userSSL=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT

3.出现错误:“Establishing SSL connection withoutserver’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 defaultif explicit option isn’t set. For compliance with existing applications notusing SSL the verifyServerCertificate property is set to ‘false’. You needeither to explicitly disable SSL by setting useSSL=false, or set useSSL=trueand provide truststore for server certificate verification.”


4.出现错误:“java.sql.SQLException: The server time zonevalue ‘???ú±ê×??±??’ is unrecognized or represents more than one time zone. Youmust configure either the server or JDBC driver (via the serverTimezoneconfiguration property) to use a more specifc time zone value if you want toutilize time zone support.”





您的电子邮箱地址不会被公开。 必填项已用*标注