springboot 数据源配置出错(Failed to configure a DataSource: ‘url‘ attribute is not ...)

84 阅读1分钟

springboot 数据源配置出错

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

1、yml 和 启动类中配置出问题(pom文件中配置了druid)

在这里插入图片描述 此处配置了druid

在启动类中则不能写成以下形式

@SpringBootApplication({exclude = {DruidDataSourceAutoConfigure.class} )

只能写成

@SpringBootApplication

在这里插入图片描述

或者删除yml中的Druid配置

2、yml中没有配置druid

则启动类写成以下形式,(pom文件中配置了druid)

@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)//排除自动配置

程序入口处:
 
@SpringBootApplication
public class DemoApplication {
 
修改为:
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
public class DemoApplication {

3、解决方案

如果以上方法不行那就,将pom文件带有数据库相关的删除,例如:jdbc、mysql-connect等等