SpringBoot集成FlyWay之踩坑记录

Maven

官网最新版目前为6.2.4

<dependency>
            <groupId>org.flywaydb</groupId>
            <artifactId>flyway-core</artifactId>
            <version>6.2.4</version>
</dependency>

关于SpringBoot集成FlyWay这块不做过多介绍 百度搜索有很多文章借鉴

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
org.flywaydb.core.api.FlywayException: Unable to parse statement in
db/migration/V1__autosale.sql at line 20 col 1: Incomplete statement
at line 20 col 1: – ----------------------------

分析日志看到错误在 V1__autosale.sql 中第20行 我们来到sql脚本中查看 第20行为 – ---------------------------- 其实日志中已经给出答案 就是无法解析这行代码 我们把带 – ---------------------------- 的全部删除 重新启动
启动成功

这个问题出在从Navicat中导出SQL脚本时 默认给我们带了一些注释 而FlyWay无法解析 删除即可