自己简单创建了一个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