springboot项目报错Failed to configure a DataSource: 'url' attribute is not specified and no embedded

桃扇骨 2023-05-31 03:00 14阅读 0赞

SpringBoot集成Mybatis等可能会报错如下:

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
    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).  
       
       
    Process finished with exit code 1

问题分析及解决方案

1、DataSourceAutoConfiguration会自动加载.可以排除此类的自动配置，在启动类中加入

@SpringBootApplication(exclude= \{DataSourceAutoConfiguration.class\})

2、在application.properties或者application.yml文件中没有添加数据库配置信息.导致错误，加入数据源即可

spring:  
        datasource:  
          url: jdbc:mysql://localhost:3306/seckill?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false  
          username: root  
          password:  
          driver-class-name: com.mysql.jdbc.Driver  
          type: com.alibaba.druid.pool.DruidDataSource  
          filters: stat

3、还有一种错误，是基于第二种的，自己配置了数据源发现还是报同样的错误，新手也很容易犯的错误，就是在使用yml文件配置的时候在配置属性的前面习惯性的有一个或者几个空格或是一个“Tab”，如下：

在yml文件中配置的属性前面是不允许有缩进的，解决办法就是不缩进，该问题解决。改成如下。将缩进去掉即可，使用yml文件配置一定要注意格式，不然细节将会引起大错误

springboot项目报错Failed to configure a DataSource: 'url' attribute is not specified and no embedded

发表评论取消回复

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

相关阅读

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

相关【error】Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource

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

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

相关 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 embedded

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

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

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

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