‘url‘ attribute is not specified and no embedded datasource could be configured.

自己简单创建了一个SpringBoot + myBatis 项目没有在application.properties中对数据源进行配置

错误信息

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2020-09-23 22:35:02.462 ERROR 8864 --- [           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:

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).

Disconnected from the target VM, address: '127.0.0.1:55253', transport: 'socket'

Process finished with exit code 1

错误分析:Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

配置数据源失败:未指定'url'属性,且无法配置嵌入式数据源

简单的说就是没有在配置文件中对数据源进行配置

解决办法:

办法一、启动类注解修改为@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})

作用:加载时排除数据源自动配置

package com.example.demo;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

办法二、在配置文件中进行数据源配置(application.properties)

#数据库连接配置
spring.datasource.url = jdbc:mysql://localhost:3306/demo_db
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.max-active=10
spring.datasource.max-idle=10
spring.datasource.min-idle=5
spring.datasource.initial-size=5

 

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值