Java-改用mysql8报错，com.mysql.jdbc.Driver 已经过时了，使用新的驱动 com.mysql.cj.jdbc.Driver

原创已于 2022-08-23 10:19:30 修改 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #jvm #intellij-idea

于 2022-08-23 10:11:05 首次发布

WT 专栏收录该内容

28 篇文章

订阅专栏

本文分析了MybatisPlus应用启动时遇到的过时MySQL驱动问题，展示了如何配置新驱动，并重点介绍了MySQL8.0连接设置。

/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/bin/java -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=53759:/Applications/IntelliJ IDEA.app/Contents/bin -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -Dfile.encoding=UTF-8 -classpath /Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/cat.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/crs-agent.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/legacy8ujsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/openjsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/tools.jar:/Users/zhou/IdeaProjects/mybatis-plus/target/classes:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-web/2.5.10/spring-boot-starter-web-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter/2.5.10/spring-boot-starter-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot/2.5.10/spring-boot-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-logging/2.5.10/spring-boot-starter-logging-2.5.10.jar:/Users/zhou/repository/ch/qos/logback/logback-classic/1.2.10/logback-classic-1.2.10.jar:/Users/zhou/repository/ch/qos/logback/logback-core/1.2.10/logback-core-1.2.10.jar:/Users/zhou/repository/org/apache/logging/log4j/log4j-to-slf4j/2.17.1/log4j-to-slf4j-2.17.1.jar:/Users/zhou/repository/org/apache/logging/log4j/log4j-api/2.17.1/log4j-api-2.17.1.jar:/Users/zhou/repository/org/slf4j/jul-to-slf4j/1.7.36/jul-to-slf4j-1.7.36.jar:/Users/zhou/repository/jakarta/annotation/jakarta.annotation-api/1.3.5/jakarta.annotation-api-1.3.5.jar:/Users/zhou/repository/org/yaml/snakeyaml/1.28/snakeyaml-1.28.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-json/2.5.10/spring-boot-starter-json-2.5.10.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-databind/2.12.6/jackson-databind-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-annotations/2.12.6/jackson-annotations-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-core/2.12.6/jackson-core-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/datatype/jackson-datatype-jdk8/2.12.6/jackson-datatype-jdk8-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/datatype/jackson-datatype-jsr310/2.12.6/jackson-datatype-jsr310-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/module/jackson-module-parameter-names/2.12.6/jackson-module-parameter-names-2.12.6.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-tomcat/2.5.10/spring-boot-starter-tomcat-2.5.10.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-core/9.0.58/tomcat-embed-core-9.0.58.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-el/9.0.58/tomcat-embed-el-9.0.58.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-websocket/9.0.58/tomcat-embed-websocket-9.0.58.jar:/Users/zhou/repository/org/springframework/spring-web/5.3.16/spring-web-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-beans/5.3.16/spring-beans-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-webmvc/5.3.16/spring-webmvc-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-aop/5.3.16/spring-aop-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-context/5.3.16/spring-context-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-expression/5.3.16/spring-expression-5.3.16.jar:/Users/zhou/repository/org/slf4j/slf4j-api/1.7.36/slf4j-api-1.7.36.jar:/Users/zhou/repository/org/springframework/spring-core/5.3.16/spring-core-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-jcl/5.3.16/spring-jcl-5.3.16.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-boot-starter/3.0.5/mybatis-plus-boot-starter-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus/3.0.5/mybatis-plus-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-extension/3.0.5/mybatis-plus-extension-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-core/3.0.5/mybatis-plus-core-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-annotation/3.0.5/mybatis-plus-annotation-3.0.5.jar:/Users/zhou/repository/com/github/jsqlparser/jsqlparser/1.2/jsqlparser-1.2.jar:/Users/zhou/repository/org/mybatis/mybatis-spring/1.3.2/mybatis-spring-1.3.2.jar:/Users/zhou/repository/org/mybatis/mybatis/3.4.6/mybatis-3.4.6.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-generator/3.0.5/mybatis-plus-generator-3.0.5.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-autoconfigure/2.5.10/spring-boot-autoconfigure-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-jdbc/2.5.10/spring-boot-starter-jdbc-2.5.10.jar:/Users/zhou/repository/com/zaxxer/HikariCP/4.0.3/HikariCP-4.0.3.jar:/Users/zhou/repository/org/springframework/spring-jdbc/5.3.16/spring-jdbc-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-tx/5.3.16/spring-tx-5.3.16.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-configuration-processor/2.5.10/spring-boot-configuration-processor-2.5.10.jar:/Users/zhou/repository/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar:/Users/zhou/repository/org/projectlombok/lombok/1.18.24/lombok-1.18.24.jar com.nanjing.mybatisplus.MybatisPlusApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::               (v2.5.10)

2022-08-23 00:26:16.782  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : Starting MybatisPlusApplication using Java 1.8.0_345 on ZHOUdeiMac.lan with PID 5443 (/Users/zhou/IdeaProjects/mybatis-plus/target/classes started by zhou in /Users/zhou/IdeaProjects/mybatis-plus)
2022-08-23 00:26:16.783  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : No active profile set, falling back to 1 default profile: "default"
2022-08-23 00:26:17.223  INFO 5443 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2022-08-23 00:26:17.226  INFO 5443 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-08-23 00:26:17.227  INFO 5443 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.58]
2022-08-23 00:26:17.258  INFO 5443 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-08-23 00:26:17.258  INFO 5443 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 449 ms
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
 _ _   |_  _ _|_. ___ _ |    _ 
| | |\/|_)(_| | |_\  |_)||_|_\ 
     /               |         
                        3.0.5 
2022-08-23 00:26:17.322  INFO 5443 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2022-08-23 00:26:17.322  WARN 5443 --- [           main] com.zaxxer.hikari.util.DriverDataSource  : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-08-23 00:26:17.484  INFO 5443 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
Property 'mapperLocations' was not specified or no matching resources found
2022-08-23 00:26:17.722  INFO 5443 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2022-08-23 00:26:17.728  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : Started MybatisPlusApplication in 1.118 seconds (JVM running for 1.372)

com.mysql.jdbc.Driver 已经过时了，使用新的驱动 com.mysql.cj.jdbc.Driver

MySQL8.0连接配置

MySQL在高版本需要指明是否进行SSL连接

jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC