今天在使用Spring Boot开发项目时项目,启动Spring Boot,报错,报错内容如下:
***************************
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).
原因分析:项目工程没有配置数据库。
解决方法:配置H2数据库或者MySQL数据库,其中配置MySQL解决方法如下:
1、添加 MySQL连接驱动的依赖(注意自己的驱动版本)
Maven工程在pom.xml中添加
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
2、在application.properties中添加MySQL数据库配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/blog?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.username=用户名 spring.datasource.password=密码
3.刷新项目,重新启动程序即可。