Notes on upgrading to mysql-connector-java8.0.27

Recently, an online security scan found a vulnerability in the MySQL connector. I checked and found that the version used was 5.1.47, which is indeed a long time ago.

It is recommended to upgrade to the latest version 8.0.27

There are always some problems with upgrades. After changing the connector, the deployment reported an error.

### Error querying database. Cause: java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Can't connect to the database

I searched the configuration file and found that the class for the connection pool configuration connection could not be found.

After switching back to mysql-connector-java 5.1.47, this class can be found

Checking the jar package source code, I found that after changing mysql-connector-java 8.0.27, the path of the class connecting to jdbc has changed, which is a big pit.

Finally, just change it to com.mysql.cj.jdbc.MysqlDataSource

Finally, attach the database connection configuration of mysql8.0+

jdbc.driverClassName=com.mysql.cj.jdbc.Driver

jdbc.url=jdbc:mysql://*****?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true

The rest of the framework configuration is

<spring_version>4.3.29.RELEASE</spring_version>

<mybatis_version>3.4.0</mybatis_version>

<mybatis_spring_version>1.3.0</mybatis_spring_version>

This is the end of this article about the precautions for upgrading to mysql-connector-java8.0.27. For more information about mysql-connector-java8.0.27, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!