无法实例化H2

Question

我正在尝试将H2设置为内存数据库。我已将其配置为：

spring:
  profiles: qa
  datasource:
    #url: jdbc:h2:mem:testdb;MODE=MySQL;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE SCHEMA IF NOT EXISTS "public"
    jdbc-url: jdbc:mysql://localhost:3306/lisdashboard
    username: '@lisdashboard.db.username@'
    password: '@lisdashboard.db.password@'
  h2:
    console:
      path: /admin/h2-console

然而，当我尝试运行它时，我会遇到这个错误

- Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Driver org.h2.Driver claims to not accept jdbcUrl, jdbc:mysql://localhost:3306/lisdashboard
-

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
- Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: 

Invocation of init method failed; nested exception is java.lang.RuntimeException: Driver org.h2.Driver claims to not accept jdbcUrl, jdbc:mysql://localhost:3306/lisdashboard

我不确定它为什么不接受jdbc url，我的confg格式有什么问题吗？

Answer 1

如果您想使用H2，您的配置应该如下所示：

spring:
  profiles: qa
  datasource:
    url: jdbc:h2:mem:testdb;MODE=MySQL;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATE SCHEMA IF NOT EXISTS "public"
    username: '@lisdashboard.db.username@'
    password: '@lisdashboard.db.password@'
  h2:
    console:
      path: /admin/h2-console

你在URL前面有一个#和#是YAML中的一条评论

Answer 2

您正在使用MySQL jdbc url尝试连接到H2实例。

要使用urljdbc:h2:mem:而不是现在使用的配置，您需要更换配置mysql://localhost:3306/lisdashboard。

如果您想使用不同类型的H2实例，请查看文档以查看替代方案（例如文件实例）。