SpringBoot搭建报错:Failed to configure a DataSource: ‘url’ attribute is not specified and no embedded datasource could be configured.
一、详细错误:
1、idea报错如下
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).
2、错误源码:
我这里的配置文件的是application.yml
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
二、原因
application.yml(或application.properties)文件配置错误,我这里是由于前缀属性之间少了缩进而导致的错误
三、修改
url、 driver-class-name、username、password等同级属性添加缩进即可
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
四、总结
1、属性和属性值之间是有空格的,如果不加空格属性是不变色的,加了空格口属性会变为橙色。
2、前缀属性之间需要缩进,否则报错。
错误写法:
正确写法: