spring boot启动报错Error starting ApplicationContext（未能配置数据源）

傷城~ 2021-07-24 16:53 479阅读 0赞

主要错误：  
`Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.`

未能配置数据源:未指定“url”属性，也无法配置嵌入式数据源。

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
    2019-06-03 09:47:45.300 ERROR 23160 ---
     [    //加入Java开发交流君样：756584822一起吹水聊天 
      main] o.s.b.d.LoggingFailureAnalysisReporter   : 
     
    ***************************
    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:
     //加入Java开发交流君样：756584822一起吹水聊天
    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).

原因：

## spring boot默认会加载 ##

`org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration`类，`DataSourceAutoConfiguration`类使用了`@Configuration`注解向`spring`注入了dataSource bean。因为工程中没有关于`dataSource`相关的配置信息，当spring创建`dataSource bean`因缺少相关的信息就会报错。

## 两种解决办法 ##

**1.在Application类上加**  
\`  
@EnableAutoConfiguration(exclude=\{DataSourceAutoConfiguration.class\})

**2.配置数据源：**

例如在application配置文件中：

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql:
    //ip:端口号/数据库名称?
    useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8

![image][]

[**最新2020整理收集的一些高频面试题（都整理成文档），有很多干货，包含mysql，netty，spring，线程，spring cloud、jvm、源码、算法等详细讲解，也有详细的学习规划图，面试题整理等，需要获取这些内容的朋友请加Q君样：756584822**][2020_mysql_netty_spring_spring cloud_jvm_Q_756584822]

[image]: /images/20210724/d21b8d158b0d43cfb1c4d11554ab62b9.png
[2020_mysql_netty_spring_spring cloud_jvm_Q_756584822]: https://jq.qq.com/?_wv=1027&k=0IsBuUb0