【记录】java.sql.SQLException: com.mysql.cj.jdbc.Driver异常

最新推荐文章于 2024-06-03 12:00:58 发布
原创 最新推荐文章于 2024-06-03 12:00:58 发布 · 6.7k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#SpringBoot

本文详细记录了在Spring Boot项目中使用Druid连接池配置MySQL数据库时遇到的驱动类找不到的问题，以及如何通过调整依赖版本和设置时区来解决这些问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

java.sql.SQLException: com.mysql.cj.jdbc.Driver
at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:600) ~[druid-1.1.10.jar:1.1.10]
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:817) ~[druid-1.1.10.jar:1.1.10]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_121]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_121]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1929) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1871) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:874) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:778) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:226) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.lambda0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:874) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:778) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:226) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:874) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:778) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:226) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.lambdadoGetBean0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:400) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.lambda0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:400) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:400) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.lambdadoGetBean0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:315)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1226)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1215)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atcom.demo.demo.DemoApplication.main(DemoApplication.java:13)[classes/:?]Causedby:java.lang.ClassNotFoundException:com.mysql.cj.jdbc.Driveratjava.net.URLClassLoader.findClass(URLClassLoader.java:381) [?:1.8.0121]atjava.lang.ClassLoader.loadClass(ClassLoader.java:424) [?:1.8.0121]atsun.misc.Launcher0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108) [spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) [spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) [spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE] at com.demo.demo.DemoApplication.main(DemoApplication.java:13) [classes/:?] Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_121] at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_121] at sun.misc.Launcher0(AbstractBeanFactory.java:323) [spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)[spring−beans−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)[spring−context−5.2.1.RELEASE.jar:5.2.1.RELEASE]atorg.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:315)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1226)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1215)[spring−boot−2.2.1.RELEASE.jar:2.2.1.RELEASE]atcom.demo.demo.DemoApplication.main(DemoApplication.java:13)[classes/:?]Causedby:java.lang.ClassNotFoundException:com.mysql.cj.jdbc.Driveratjava.net.URLClassLoader.findClass(URLClassLoader.java:381) [?:1.8.01​21]atjava.lang.ClassLoader.loadClass(ClassLoader.java:424) [?:1.8.01​21]atsun.misc.LauncherAppClassLoader.loadClass(Launcher.java:331) ~[?:1.8.0_121]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_121]
at java.lang.Class.forName0(Native Method) ~[?:1.8.0_121]
at java.lang.Class.forName(Class.java:264) ~[?:1.8.0_121]
at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:598) ~[druid-1.1.10.jar:1.1.10]
… 47 more

发现问题:

在这里插入图片描述

解决问题:
在这里插入图片描述
去掉我们自己定义的版本号，使用springBoot 约定好的版本。

然后发现时区又出现了问题，这个好搞:

java.sql.SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone.

在这里插入图片描述
手动设置一下 serverTimezone=GMT 就好了。

在这里插入图片描述

9233
关注
java.sql.SQLException: com.mysql.jdbc.Driver
【优快云】
03-08 3143
缺少jdbc对mysql的jar 在 pom.xml 中，加入 mysql 的 maven 引用。 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38&...
解决error {dataSource-1} init error java.sql.SQLException: com.mysql.cj.jdbc.Driver
qq_61604164的博客
05-18 7469
七月 08, 2019 2:39:14 下午 com.alibaba.druid.pool.DruidDataSource error 严重:error {dataSource-1} init error java.sql.SQLException: com.mysql.cj.jdbc.Driver at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:520) at com.alibaba.druid.pool.DruidDa.
java.sql.SQLException: com.mysql.cj.jdbc.Driver
沐雨橙风ιε的博客
09-02 2649
java.sql.SQLException: com.mysql.cj.jdbc.Driver
java.sql.SQLExcption：com.mysql.cj.jdbc. Driver问题
最新发布
2201_75705369的博客
06-03 1070
下载好把 mysql-connector-j-8.2.0.jar 移至自己项目中。你的项目驱动需要用的是mysql8的驱动。出现这个问题是mysql的驱动存在问题。你引入的应该是 mysql5的驱动。mysql8 驱动下载地址。项目重新启动就解决了。
解决java.sql.SQLException: com.mysql.cj.jdbc.Driver报错
weixin_54246980的博客
03-14 1万+
类似这两类的报错的时候经总结可能有如下几个问题： 1.首先检查你的jar/pom文件的mysql版本号: mysql5.x.x的版本配置应为:"com.mysql.jdbc.driver" mysql6.x.x及在6以上的版本配置应为："com.mysql.cj.jdbc.driver"
报错：java.sql.SQLException: com.mysql.cj.jdbc.Driver
热门推荐
邓商羽的博客
09-23 3万+
在IDEA里用Spring Initializr创建了一个SpringBoot项目，mybatis链接mysql数据库时报以下错误 2019-09-23 15:23:19.211 INFO 4568 --- [nio-8888-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/demo] : Initializing Spring DispatcherSe...
服务器出现java.sql.SQLException No suitable driver found for 的.pdf
12-05
在进行Servlet开发过程中，尤其是在尝试连接数据库时，遇到了一个常见的异常：“java.sql.SQLException: No suitable driver found for”。此异常通常表明Java应用程序未能找到合适的JDBC驱动程序来连接数据库。 ##...
【已解决】ERROR [main] - {dataSource-1} init errorjava.sql.SQLException: ${jdbc.driver}
哈哈
10-21 2129
所以SqlSessionFactoryBean的id不能是sqlSessionFactory吗？3. 把applicationContext.xml配置文件重新写了一遍运行成功了。1. database.properties没有问题。2. 把数据库版本提高了,再次运行还是报错。发现只有一个id不一样，离谱啊。
### Error updating database. Cause: java.sql.SQLException: Incorrect integer value: ‘**‘ for column
qq_61604164的博客
05-18 5760
问题： com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl.error {dataSource-1} init error java.sql.SQLException: com.mysql.cj.jdbc.Driver
关于JDBC连接出现java.sql.SQLException: com.mysql.cj.jdbc.Driver/Caused by: java.lang.ClassNotFoundExceptio
HFJsjsn的博客
04-15 3328
原因：该错误是因为mysql连接和配置文件所对应的连接地址不同导致。就把driver=com.mysql.cj.jdbc.Driver。就是8版本以上写：com.mysql.cj.jdbc.Driver。就把driver=com.mysql.jdbc.Driver。8版本一下写：com.mysql.jdbc.Driver。这是因为在8版本以后mysql的包名换了。
解决方法dataSource init error java.sql.SQLException: com.mysql.cj.jdbc.Driver
qq_39202382的博客
07-08 1万+
使用mysql+druid时报错 这是报错信息折腾了好久。 七月 08, 2019 2:39:14 下午 com.alibaba.druid.pool.DruidDataSource error 严重: dataSource init error java.sql.SQLException: com.mysql.cj.jdbc.Driver at com.alibaba.druid.util.J...
**“Caused by: java.sql.SQLException: com.mysql.cj.jdbc.Driver”解决办法**
weixin_53658416的博客
04-01 2035
“Caused by: java.sql.SQLException: com.mysql.cj.jdbc.Driver”解决办法
java.sql.SQLException: Cannot load JDBC driver class ‘com.mysql.cj.jdbc.Driver‘错误
weixin_51969378的博客
01-27 1695
可能是由于驱动版本或者tomcat版本引起的，8.0.22的mysql-connector要用9.0.37的tomcat，8.0以上的jar驱动包连接数据库要带cj（driver）。
【解决】dataSource init error java.sql.SQLException: com.mysql.cj.jdbc.Driver
weixin_43902063的博客
04-12 2834
这个问题我碰到了两次，第一次百度解决了。第二次就忘了怎么解决了。 所以遇到问题还是要总结！总结！总结！ 首先我这个问题的原因是因为这个jar包版本太低，原来是5点多的版本，现在下载了最新版本就好了 下载教程，这个博主总结的很详细 mysql-connector-java的jar包下载流程 ...
版本问题导致的坑--java.sql.SQLException: com.mysql.jdbc.Driver
PickRecalled
06-27 5149
直入主題,如下错误信息 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in URL [file:/Users/shuang/git/excel-file-import/excel-file-import/target/clas...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值