解决If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.

最新推荐文章于 2025-03-09 13:55:14 发布

往昔时光

最新推荐文章于 2025-03-09 13:55:14 发布

阅读量1.1k

点赞数 2

分类专栏： ⑦ 开发时遇到的问题文章标签：数据库 springcloud spring boot

本文链接：https://blog.youkuaiyun.com/WLKUYM/article/details/136987328

版权

⑦ 开发时遇到的问题专栏收录该内容

27 篇文章

订阅专栏

控制台报错信息
表示没有指定的数据库url，无法配置数据库
***************************
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

方法一：不使用数据源配置
我们可以在Spring Boot项目入口注解处添加 exclude= {DataSourceAutoConfiguration.class}，表示取消数据源的自动配置

如：

/**
 * 表示取消数据源的自动配置
 */
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})
public class SpringbootWeb01Application {
 
    public static void main(String[] args) {
        SpringApplication.run(SpringbootWeb01Application.class, args);
    }
 
}

方法二：按照报错，我们添加数据库配置
我们需要application.yml文件下添加如下配置

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456