26

I am using java 11, and I have added flyway in spring-boot application like below.

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation group: 'mysql', name: 'mysql-connector-java', version: '8.0.29'
    implementation group: 'org.springframework.boot', name: 'spring-boot-starter-data-jpa', version: '2.7.0'
    implementation group: 'org.flywaydb', name: 'flyway-core', version: '8.5.13'
    compileOnly 'org.projectlombok:lombok'
    annotationProcessor 'org.projectlombok:lombok'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

and added properties as

# flyway
spring.flyway.baseline-on-migrate=true
spring.flyway.enabled=false
#spring.flyway.enabled=true
spring.flyway.locations=classpath:db/migration

but it is producing an error that, org.flywaydb.core.api.FlywayException: Unsupported Database: MySQL 8.0

Output

Sandeep Patel
  • 2,069
  • 2
  • 14
  • 20

2 Answers2

49

You should add flyway-mysql dependency.

Maven :

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-mysql</artifactId>
</dependency>

Gradel:

dependencies {
    compile "org.flywaydb:flyway-mysql"
}

More information here.

Oussama ZAGHDOUD
  • 1,767
  • 5
  • 15
3

The only way that worked for me was to add these dependencies to build.gradle:

implementation 'org.flywaydb:flyway-core:8.4.4'
implementation 'org.flywaydb:flyway-mysql:8.4.4'

As shown here

Martin Maťovčík
  • 101
  • 1
  • 4