In the work I'm currently involved in, I decided to change from Java7 to Java11 and MySQL5.5 to MySQL8.0, so this is a memo for that.
Select the 8.x one from the Maven repository and get it.
https://mvnrepository.com/artifact/mysql/mysql-connector-java
I'm Gradle, so I rewrote it as follows.
implementation "mysql:mysql-connector-java:8.0.17"
Before change: com.mysql.jdbc.Driver After change: com.mysql.cj.jdbc.Driver
URL
Before change: jdbc: mysql: // localhost: 3306 / test After change: jdbc: mysql: // localhost: 3306 / test? characterEncoding = utf8 & useSSL = false & serverTimezone = GMT% 2B9 & rewriteBatchedStatements = true
I don't understand it yet, but it seems that I need to add various things to the back. serverTimezone = GMT% 2B9 seems to specify the Japanese time zone "GMT + 9".
There are too many changes and it's hard ...
Recommended Posts