SpringBoot笔记：（2）引入Druid数据库连接池报Error creating bean with name 'druidDataSource'...异常

最新推荐文章于 2024-07-27 21:31:09 发布
最新推荐文章于 2024-07-27 21:31:09 发布
阅读量2.3w 收藏 9
点赞数 6
分类专栏： SpringBoot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiaozhiL/article/details/80286248
版权

按照 Druid 官方文档的介绍，原以为 SpringBoot 中对其引入是一件轻而易举的事，怎奈这过程中出现了一个雷……

Druid SpringBoot Starter 官方介绍网址：点击打开链接


pom.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>cn.ultimate.springboot</groupId>
  <artifactId>cn.test.springboot</artifactId>
  <version>1.0-SNAPSHOT</version>
  <name>cn.test.springboot</name>


    <!-- 继承默认的springboot-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.1.RELEASE</version>
    </parent>

    <!-- Web 应用程序依赖包 -->
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- mysql 驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!-- mybatis    -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </dependency>


        <!-- 配置druid  数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.9</version>
        </dependency>

    </dependencies>
    
</project>

application.yml  数据库配置

spring:
    datasource:
        url: jdbc:mysql://localhost:3306/spring?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
        username: root
        password:
        initialSize: 2
        minIdle: 1
        maxActive: 50
        maxWait: 60000
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: select 'x'
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        maxPoolPreparedStatementPerConnectionSize: 20
        maxOpenPreparedStatements: 20
        filters: config,wall,stat
        connectionProperties: druid.stat.slowSqlMillis=200;druid.stat.logSlowSql=true;config.decrypt=true

Druid bean注入配置

@Configuration
public class DruidConfig {
    @Primary
    @Bean
    public DataSource druidDataSource(){
        return DruidDataSourceBuilder.create().build();
    }

}
启动报异常 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'druidDataSource': Unsatisfied dependency expressed through field 'basicProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/embedded/EmbeddedDatabaseType
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:587) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1344) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:578) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:760) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869) ~[spring-context-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) [spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) [spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) [spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) [spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) [spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at cn.ultimate.springboot.App.main(App.java:18) [classes/:na]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/embedded/EmbeddedDatabaseType
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1232) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1131) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:541) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:251) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1065) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:584) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	... 19 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/embedded/EmbeddedDatabaseType
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:182) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1224) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	... 30 common frames omitted
Caused by: java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/embedded/EmbeddedDatabaseType
	at org.springframework.boot.jdbc.EmbeddedDatabaseConnection.<clinit>(EmbeddedDatabaseConnection.java:50) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.<init>(DataSourceProperties.java:152) ~[spring-boot-autoconfigure-2.0.1.RELEASE.jar:2.0.1.RELEASE]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_151]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_151]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_151]
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:170) ~[spring-beans-5.0.5.RELEASE.jar:5.0.5.RELEASE]
	... 32 common frames omitted
Caused by: java.lang.ClassNotFoundException: org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType
	at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[na:1.8.0_151]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_151]
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) ~[na:1.8.0_151]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_151]
	... 39 common frames omitted

从异常的内容可以知道无法创建druidDataSource实例是由于找到不这个类。

org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType

根据这个类的绝对路径我们可以推测出我们的项目缺少了 springframework.jdbc 这个jar包，在pom.xml中添加依赖

 <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
 </dependency>

再次启动项目，果不其然，项目顺利启动了。

至于 Druid  SpringBoot  Starter 在哪里引用了这个类，大家只要跟踪一下源代码，就可以很快找到了

org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType


夕陌笔记
关注
专栏目录
Springboot + mybatisPlus + druid 启动失败的错误记录
qq_40829225的博客
02-17 1293
Caused by: java.sql.SQLException: com.mysql.cj.jdbc.Driver Caused by: java.sql.SQLException: Access denied for user ‘***’@‘localhost’ (using password: YES) org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’
异常： Error creating bean with name ‘org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfig
Java Punk
12-21 9624
是数据库jdbc连接异常造成的启动失败
Error creating bean with name 'dataSource'...Failed to determine a suitable driver class
afan3862的博客
08-10 302
场景： 新建的spring-boot maven mybatis工程，运行时报以下异常 16:04:10.751 [main] ERROR org.springframework.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springfr...
org.springframework.beans.factory.UnsatisfiedDependencyException
最新发布
m0_74613536的博客
07-27 692
Service@Autowired附。
springboot 引入Druid数据库报 Error creating bean with name ‘druidDataSource‘ ... 异常
weixin_63705087的博客
12-29 2434
springboot 引入Druid数据库报 Error creating bean with name 'druidDataSource' ... 异常
Sping boot加入Druid连接池异常之Error creating bean with name 'dataSource'
pandalovey的博客
11-11 6100
配置Druid数据连接池之后一直报错找不到数据源 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userController': Unsatisfied dependency expressed through field 'userMapper'...
mysql-connector-java版本匹配问题ERROR DruidDataSource - create connection SQLException
寇塔空的博客
06-24 9920
装新环境mysql使用的5.8版本，启动项目后发现报错连接不上数据库 Druid-ConnectionPool-Create-150783284] ERROR DruidDataSource - create connection SQLException, url: jdbc:mysql://localhost:3306/db_plat?allowMultiQueries=true&us...
[MySQL ERROR] XXX.DruidDataSource - create connection error...errorCode 1698, state28000错误的解决方案
qq_41969790的博客
04-06 4012
1、问题描述 出错描述如题，SpringBoot后台应用程序使用了Druid连接池，SpringBoot后台服务程序在本地测试和上线一开始都没有问题（也可能是因为我没有长时间测试），后台程序在阿里云服务器上运行一段时间后，某天打开测试发现没有响应，查看系统错误日志，如下： 2020-04-06 00:01:00.641 [ERROR] c.alibaba.druid.pool.DruidDa...
SpringBoot开发案例之配置Druid数据库连接池的示例
08-27
SpringBoot开发案例之配置Druid数据库连接池的示例 在本篇文章中，我们将学习如何在Spring Boot应用程序中配置Druid数据库连接池。Druid是一个来自阿里系的开源连接池，提供了非常优秀的监控功能。我们将了解如何在...
SpringBoot整合Druid数据库连接池的方法
08-18
SpringBoot整合Druid数据库连接池的方法 在本文中，我们将讨论如何在SpringBoot项目中整合Druid数据库连接池。Druid是Java语言中最好的数据库连接池，能够提供强大的监控和扩展功能。 什么是Druid？ Druid是Java...
SpringBoot整合Mybatis使用Druid数据库连接池
08-27
SpringBoot 整合 Mybatis 使用 Druid 数据库连接池 Spring Boot 是一个基于 Java 的框架，提供了快速开发和生产级别的应用程序的能力。Mybatis 是一个基于 Java 的持久层框架，提供了对数据库的访问和操作的能力。...
SpringBoot2.0整合Druid连接池详细步骤.docx
11-18
SpringBoot2.0 整合 Druid 连接池是目前流行的解决方案之一，Druid 是阿里巴巴开源的数据库连接池，提供了高效、安全、可靠的数据库连接解决方案。本文将详细介绍 SpringBoot2.0 整合 Druid 连接池的步骤。 pom ...
java用druid连接池与数据库建立链接时无法使用createDataSource（）方法问题
等哈哆
05-08 4289
如图，用DruidDataSourceFactor时无其他方法。 ctrl+b看一下DruidDataSourceFactor； package com.alibaba.druid.support.ibatis; import com.ibatis.sqlmap.engine.datasource.DataSourceFactory; import java.util.Map; import ...
Springboot整合druid+mybatis 报错UnsatisfiedDependencyException: Error creating bean with name ‘dataSourc
weixin_36862250的博客
03-26 740
SSL(Secure Sockets Layer 安全套接字协议)，在mysql进行连接的时候,如果mysql的版本是5.7之后的版本必须要加上useSSL=false,mysql5.7以及之前的版本则不用进行添加useSSL=false，会默认为false，一般情况下都是使用useSSL=false，尤其是在将项目部署到linux上时，一定要使用useSSL=false！重点在url没有在useSSL=false参数。
SpringBoot+Druid测试连接不上的问题，报错 ‘url’ attribute is not specified and no embedded datas
m0_62780794的博客
03-12 942
操作系统：windows10家庭中文版集成开发环境：idea2022.03框架：SpringBoot 3.2.3Druid: 1.2.19版本。
springboot+druid报错 create connection SQLException, url: null, errorCode 0, state 08001
zhengbingmei的博客
03-11 5539
springboot+druid报错 url: null 错误提示： 解决办法： 错误提示： 2019-05-08 23:44:44.707 ERROR 6660 — [eate-1516759394] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: null, errorCode 0, s...
Error creating bean with name 'dataSource' defined in class path resource [com/alibaba/druid/spring/
Angus
03-24 5805
# # 原因在于： DruidDataSourceAutoConfigure在DynamciDataSourceAutoConfiguration之前，其会注入一个DataSourceWrapper，会在原生的spring.datasource下找url,username,password等。而我们动态数据源的配置路径是变化的。 # #解决方案 当你的springboot项目使用dr...
记一次线上问题-Druid数据源配置失败
诺言的专栏
03-07 1270
mysql string druid
SpringBoot中使用Druid配置多数据源
运气不好努力来凑
01-10 2049
SpringBoot2.0整合druid1.1.9。一文教你连接多数据源，已成功。
Error creating bean with name 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties'
09-17
根据提供的引用内容，你遇到的问题是"Error creating bean with name 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties'"。造成这个问题的原因可能有两种：数据源版本太低或者数据源自动配置出现错误。 解决方法一：提高数据源的版本。你可以将数据源的版本升级到1.1.10，例如druid的版本可以提升到1.1.10。具体的步骤是在pom.xml文件中将druid的依赖版本改为1.1.10，如下所示： ``` <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.10</version> </dependency> ``` 解决方法二：排除数据源自动配置。你可以在启动类上面加上`@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class})`这个注解，来排除数据源自动配置的错误。如下所示： ``` @EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class}) public class YourApplication { // ... } ``` 通过以上两种方法，你应该能够解决"Error creating bean with name 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties'"的问题。
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值