关于spring cloud项目启动异常,出现if you want an embedded database (H2, HSQL or Derby),报错

开发工具:idea

测试项目:spring cloud服务创建

按网上的操作步骤配置完成对应的配置文件后,启动项目后报错:

Description:
Failed to auto-configure a DataSource: 'spring.datasource.url' is not specified and no embedded datasource could be auto-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).

解决方案:将idea创建的yaml文件格式改为yml即可。

在网上找到的答案基本都是在启动类中增加exclude,如下:

@SpringBootApplication(exclude= {DruidDataSourceAutoConfigure.class,DataSourceAutoConfiguration.class,
        DataSourceTransactionManagerAutoConfiguration.class,
        HibernateJpaAutoConfiguration.class})

不过实际上大部分都配置了datasource,最后仔细查找发现,idea中创建的application文件类型为”yaml“!!!,不过spring boot只能识别”yml“和”properties“,导致无法读取到springboot配置文件中datasource内容,修改完成之后即可正常启动。


版权声明:本文为tsw1343451764原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。