解决java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题（真实有效）

最新推荐文章于 2024-09-20 20:34:30 发布
最新推荐文章于 2024-09-20 20:34:30 发布
阅读量1.9k 收藏 1
点赞数
分类专栏： SpringBoot
本文详细解析了在Spring Boot项目中遇到的java.lang.ClassNotFoundException:com.mysql.jdbc.Driver异常，该异常导致项目在启动时失败。文章提供了具体的错误日志，并给出了解决方案：在pom.xml文件中添加mysql-connector-java依赖。
摘要由CSDN通过智能技术生成

解决java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题（真实有效）

这个一场特别奇葩，既然这个异常存在，竟然又能编译通过，项目也不报错，只是在启动的时候，抛出异常！

一、看看这个异常

Error starting ApplicationContext.

<div class="content-detail markdown-body">
                
                <div class="markdown_views">
            <h2 id="1">数据库驱动找不到</h2>

这个一场特别奇葩，既然这个异常存在，竟然又能编译通过，项目也不报错，只是在启动的时候，抛出异常！

一、看看这个异常

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2018-06-29 19:41:42.841 ERROR 12252 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is java.sql.SQLException: com.mysql.jdbc.Driver
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:732) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:197) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1276) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1133) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:372) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1256) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1105) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1089) ~[spring-context-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:859) ~[spring-context-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) [spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) [spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) [spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) [spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) [spring-boot-2.0.3.RELEASE.jar:2.0.3.RELEASE]
    at com.gws.newframe.NewFrameApplication.main(NewFrameApplication.java:10) [classes/:na]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is java.sql.SQLException: com.mysql.jdbc.Driver
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1708) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:581) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:251) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1065) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:818) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:724) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    ... 28 common frames omitted
Caused by: java.sql.SQLException: com.mysql.jdbc.Driver
    at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:600) ~[druid-1.1.9.jar:1.1.9]
    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:815) ~[druid-1.1.9.jar:1.1.9]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_161]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_161]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1833) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1776) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1704) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
    ... 39 common frames omitted
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[na:1.8.0_161]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_161]
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338) ~[na:1.8.0_161]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_161]
    at java.lang.Class.forName0(Native Method) ~[na:1.8.0_161]
    at java.lang.Class.forName(Class.java:264) ~[na:1.8.0_161]
    at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:598) ~[druid-1.1.9.jar:1.1.9]
    ... 47 common frames omitted

Disconnected from the target VM, address: '127.0.0.1:51516', transport: 'socket'

Process finished with exit code 1

二、解决方案：增加mysql-connector-java配置

以SpringBoot项目为例，在pom.xml文件中增加以下配置：

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
</dependency>

再次启动，完美解决啦！。祝工作和学习顺利！

兆九
关注
专栏目录
关于用Vscode进行Java数据库编程出现java.lang.ClassNotFoundException:com.mysql.cj.jdbc.Driver问题详细解决方案
Protinx的博客
05-12 2224
一、最重要的一步 在加载外部库后，不能使用 Code Runner 插件运行，必须使用Java插件提供的 Run 按钮。 二、版本不对称 第一步：检查项目中是否引入mysql-connector-java驱动包，如果没引入，请先引入对应版本的该包。 第二步：检查mysql-connector-java驱动包的版本和配置的driver-class-name（驱动类名）是否一致。如果不一致会导致找不到Driver类，必须将版本和配置的驱动类名对应一致。 不同版本的mysql-con...
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
热门推荐
人生百年几今日，今日不为真可惜。
05-18 27万+
折腾了一上午，找到了这错误的原因。哎……悲剧！确认包已经被导入web工程目录。原来是tomcat找不到MYSQL JAR包的问题。后来又把mysql-connector-java-5.1.7-bin.jar导入到tomcat的lib目录下面就ok了，嘿……
JAVA报错解决方案：ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
最新发布
gitblog_06551的博客
09-20 1060
JAVA报错解决方案：ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver JAVA报错java.lang.ClassNotFoundExceptioncom.microsoft.sqlserver.jdbc.SQLServerDriver ...
关于java.lang.ClassNotFoundException: com.mysql.jdbc.Driver的解决办法
努力，直到实现为止~
07-18 4645
是tomcat找不到MYSQL JAR包的问题。把mysql-connector-java-5.1.7-bin.jar导入到tomcat的lib目录下面就ok了  在java项目中，只需要引入mysql-connector-java-5.1.7-bin.jar就可以运行java项目。 在web项目中，当Class.forName("om.mysql.jdbc.Driver");时myeclip
异常：Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
liaowenxiong的博客
01-07 1936
执行 JDBC 有关代码时，报如下的异常： 原来是配置文件的内容有问题：
eclipse 报错java.lang.ClassNotFoundException: com.mysql.jdbc.Driver错误解决
12-14
一：查看你下载的MySQL和mysql-connector-java，如果不对应的话肯定会报错。 对应规则： mysql-connector-java-5 Connector/J version Driver Type JDBC version MySQL Server version Status 5.1 4 3.0, 4.0...
解决java.lang.ClassNotFoundException: “com.mysql.cj.jdbc.Driver“ at java.net.URLClassLoader.findClass
总结复盘，才能不迷失自己！
10-16 1594
1.检查自己的mysql-connector-java驱动包有没有导入,如果是maven项目,则检查你项目下的pom.xml文件中是否引入mysql-connector-java驱动依赖: javaweb一般项目: Maven项目的pom.xml文件: <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId>
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题解决方案
Xgx120413的专栏
08-03 7068
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.securi
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
jianjian168的专栏
03-31 2107
<br />在用TOMCAT+JAVA开发时，会出现Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题。这是找不到MYSQL JAR包的问题。解决如下：<br />1.将mysql-connector-java-5.0.7-bin.jar拷贝到jsp程序的lib目录<br />2.将mysql-connector-java-5.0.7-bin.jar拷贝到tomcat6.0的lib目录<br /> <br /> <br /
idea中【java排错】java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Pruett的博客
10-15 3655
1.问题 今天在写servlet的时候用到jdbc,在Java类的测试中,能够从数据库中读出内容,但是在servlet调用函数实现jdbc读取数据的时候出现了错误,如下: 【java排错】java.lang.ClassNotFoundException: com.mysql.jdbc.Drive 2.分析 该错误的说法是找不到jdbc的驱动类 ,即 Class.forName(
Caused by: java.lang.ClassNotFoundException: Could not load requested class : com.mysql.jdbc.Driver
Shipley_Leo的博客
05-21 2416
Caused by: java.lang.ClassNotFoundException: Could not load requested class : com.mysql.jdbc.Driver
解决JDBC连接MySQL时caused by: java.lang.classnotfoundexception: com.mysql.cj.jdbc.driver问题
mo77days的博客
02-25 1318
解决JDBC连接MySQL时caused by: java.lang.classnotfoundexception: com.mysql.cj.jdbc.driver问题
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver异常
crazywsp的博客
02-28 1821
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 发现是忘记导入MySQL驱动包，导入后问题解决
java.lang.ClassNotFoundException:com.mysql.jdbc.Driver
wisher的博客
02-28 528
Intellij+Maven配置WEB项目，要连接mysql数据库，但是一直报java.lang.ClassNotFoundException:com.mysql.jdbc.Driver的错误 但是jar导入的没问题 后来发现，是属性配置文件 jdbc.properties文件的键值对的值多了空格，才导致异常
java.lang.classNotFound Exception:com.mysql.jdbc.Driver
Nodin的专栏
06-10 6319
<br />程序中连接mysql数据库时，常常会出现如下异常<br />java.lang.ClassNotFoundException: com.mysql.jdbc.Driver <br />    at java.net.URLClassLoader$1.run(URLClassLoader.java:200) <br />    at java.security.AccessController.doPrivileged(Native Method) <br />    at java.net.UR
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 解决
09-13
`java.lang.ClassNotFoundException: com.mysql.jdbc.Driver`是一个常见的Java运行时错误，它发生在试图加载Class文件时找不到对应的JDBC驱动程序。这通常发生在尝试连接MySQL数据库时，因为找不到MySql JDBC驱动...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值