Spring Boot FlywayException：无法连接到数据库。配置url、用户和密码

当我跑步时maven flyway:migrate，我收到错误

无法执行目标 org.flywaydb:flyway-maven-plugin:6.5.5:migrate （default-cli）在项目 myProject 上： org.flywaydb.core.api.FlywayException：无法连接到 数据库。配置url、用户和密码！

我的 application.yml 文件中有 Spring Boot 设置，但我猜该错误意味着它没有检测到数据库配置。这个文件 https://flywaydb.org/documentation/plugins/springboot说，“然后 Spring Boot 将自动使用其数据源自动连接 Flyway 并在启动时调用它。”如果我将配置添加到 Flyway 插件部分的 pom.xml 中，它会成功连接到数据库，但我希望它使用我的 application.yml 配置。不是 pom.xml。那么我做错了什么？

链接到有问题的存储库：https://github.com/jack-cole/BrokenSpringBoot https://github.com/jack-cole/BrokenSpringBoot

应用程序.yml

spring:
    datasource:
        driverClassName: org.postgresql.Driver
        url: "jdbc:postgresql://localhost:5433/myDB"
        username: postgres
        password: test123

依赖项：

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jooq</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.16</version>
</dependency>
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-core</artifactId>
    <version>7.0.0</version>
</dependency>

Plugins:

<plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<plugin>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-maven-plugin</artifactId>
    <version>6.5.5</version>
</plugin>

使用 Maven 运行：

无法执行目标 org.flywaydb:flyway-maven-plugin:6.5.5:migrate （default-cli）在项目 myProject 上： org.flywaydb.core.api.FlywayException：无法连接到 数据库。配置url、用户和密码！

您可以配置网址、用户名和密码在 Flyway-maven-plugin 配置中参见第一步 Maven https://flywaydb.org/documentation/getstarted/firststeps/maven

<plugin>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-maven-plugin</artifactId>
    <version>7.0.0</version>
    <configuration>
        <url>jdbc:postgresql://localhost:5433/myDB</url>
        <user>postgres</user>
        <password>test123</password>
    </configuration>
</plugin>

或使用环境变量：

mvn flyway:migrate -Dflyway.url=jdbc:postgresql://localhost:5433/myDB -Dflyway.user=postgres -Dflyway.password=test123

更多方法https://www.baeldung.com/database-migrations-with-flyway https://www.baeldung.com/database-migrations-with-flyway

使用 spring-boot 运行：

Spring Boot 在应用程序中自动配置并触发 Flyway 当您将 Flyway 核心库包含到项目中时启动。看 的用法@ConditionalOnClass(Flyway.class)在 Flyway自动配置：

@Configuration(proxyBeanMethods = false)
@ConditionalOnClass(Flyway.class)
@Conditional(FlywayDataSourceCondition.class)
@ConditionalOnProperty(prefix = "spring.flyway", name = "enabled", matchIfMissing = true)
@AutoConfigureAfter({ DataSourceAutoConfiguration.class, JdbcTemplateAutoConfiguration.class,
      HibernateJpaAutoConfiguration.class })
@Import({ FlywayEntityManagerFactoryDependsOnPostProcessor.class, FlywayJdbcOperationsDependsOnPostProcessor.class,
      FlywayNamedParameterJdbcOperationsDependencyConfiguration.class })
public class FlywayAutoConfiguration {
    ...
}

Use mvn spring-boot:run or java -jar app.jar运行应用程序

NB：还要检查迁移脚本是否在db/migration否则提供位置spring.flyway.locations财产

资源：

https://flywaydb.org/documentation/configuration/parameters/ https://flywaydb.org/documentation/configuration/parameters/

https://flywaydb.org/documentation/getstarted/firststeps/maven/ https://flywaydb.org/documentation/getstarted/firststeps/maven/

https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-execute-flyway-database-migrations-on-startup https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-execute-flyway-database-migrations-on-startup