SpringBoot 2.0 报错: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedde

叁歲伎倆 2023-01-09 12:38 438阅读 0赞

![09afb847119c8914de23269345baa503.png][]

#### 问题描述 ####

--------------------

Spring Boot项目中含有Mybatis,打Jar包运行之后,报如下错误.

***************************
    APPLICATION FAILED TO START
    ***************************
    
    Description:
    
    Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
    
    Reason: Failed to determine a suitable driver class
    
    
    Action:
    
    Consider the following:
    	If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
    	If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

![049ad2352d29fbc7a421f61dc4c2c0b5.png][]

#### 问题分析及解决方案 ####

--------------------

问题原因: Mybatis没有找到合适的加载类,其实是大部分**spring - datasource - url**没有加载成功,分析原因如下所示.

1.  **DataSourceAutoConfiguration**会自动加载.
2.  没有配置**spring - datasource - url** 属性.
3.  **spring - datasource - url** 配置的地址格式有问题.
4.  配置 **spring - datasource - url**的文件没有加载.

网上给出了这几种解决方案.

##### 方案一 (解决原因1) #####

排除此类的autoconfig。启动以后就可以正常运行。

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})

##### 方案二 (解决原因2) #####

在application.properties/或者application.yml文件中没有添加数据库配置信息.

spring:
      datasource:
        url: jdbc:mysql://localhost:3306/read_data?useUnicode=true&characterEncoding=UTF-8&useSSL=false
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver

##### 方案三 (解决原因3) #####

在spring xml配置文件中引用了数据库地址 所以需要对:等进行转义处理.但是在application.properties/或者application.yml文件并不需要转义,错误和正确方法写在下面了.

//错误示例
    spring.datasource.url = jdbc:mysql\://192.168.0.20\:1504/f_me?setUnicode=true&characterEncoding=utf8

//正确示例
    spring.datasource.url = jdbc:mysql://192.168.0.20:1504/f_me?setUnicode=true&characterEncoding=utf8

##### 方案四 (解决原因4) #####

yml或者properties文件没有被扫描到,需要在pom文件中添加如下.来保证文件都能正常被扫描到并且加载成功.

<resources>
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.yml</include>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
        <resource>
            <directory>src/main/resources</directory>
            <includes>
                <include>**/*.yml</include>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
    </resources>

#### 说明 ####

--------------------

我的问题是有原因4造成的,没有正确加载文件,其他方案均未认证其正确性,所以需要自行酌情而定.切勿盲目而为.

![1cc773b3510614b54c92ffc3dc40d24a.gif][]

[09afb847119c8914de23269345baa503.png]: /images/20221119/17fbd0703ba146f78cafdb638f4765e1.png
[049ad2352d29fbc7a421f61dc4c2c0b5.png]: https://img-blog.csdnimg.cn/img_convert/049ad2352d29fbc7a421f61dc4c2c0b5.png
[1cc773b3510614b54c92ffc3dc40d24a.gif]: /images/20221119/9cde0c56faa74f4a94b41f65f4552c08.png

SpringBoot 2.0 报错: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedde

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关项目启动bug记录：出现报错：Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedd

相关关于springboot报错：Failed to configure a DataSource ‘url‘ attribute is not specified and no embedded dat

相关 springboot项目启动提示：Failed to configure a DataSource: 'url' attribute is not specified and no embedde

相关 SpringBoot 2.0 报错: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedde

相关 springboot启动报Description: Failed to configure a DataSource: ‘url‘ attribute is not specified and no

相关新建springboot项目启动出错 Failed to configure a DataSource: 'url' attribute is not specified and no embedde

相关 SpringBoot 项目启动出错：Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedde

相关 Failed to configure a DataSource: 'url' attribute is not specified and no embedde

相关 Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could

相关 springboot项目启动报错Failed to configure a DataSource: 'url' attribute is not specified and no embedde