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

发布时间 2024-01-11 17:57:18作者: 学Java的`Bei

 

报错:

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

  

 

原因:

  SpringBoot默认会加载org. springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration类;
  DataSourceAutoConfiguration类使用了@Configuration注解向spring注入了dataSource bean;

  因为工程中没有关于dataSource相关的配置信息,当Spring创建dataSource bean因缺少相关的信息就会报错。

 

解决:

  在启动类注解后加上: @SpringBootApplication(exclude = {DataSourceAutoConfiguration.class, HibernateJpaAutoConfiguration.class})

  若不提示导包,可直接copy:

  import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
  import org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration;

 

  再次启动即可。