You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Which version and edition of Flyway are you using?
9.16.3 community edition
If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)
Yes
Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Maven plugin
Which database are you using? (Type & version)
Amazon Aurora MySQL 8.0
Which operating system are you using?
Windows 11
What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)
According to the AWS documentation it is recommended to use aws-advanced-jdbc-wrapper to connect to Aurora databases. So I used that maven dependency, set the jdbc url to jdbc:aws-wrapper:mysql://* and the driver to software.amazon.jdbc.Driver.
Flyway's Aurora MySQL support is based off of direct connection to the database instance and treating it as a MySQL connection. This AWS Wrapper JDBC driver was not part of that support as it was only introduced in September 2023 and has not been requested for support. I will add this to the proposed support list.
Which version and edition of Flyway are you using?
9.16.3 community edition
If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)
Yes
Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Maven plugin
Which database are you using? (Type & version)
Amazon Aurora MySQL 8.0
Which operating system are you using?
Windows 11
What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)
According to the AWS documentation it is recommended to use aws-advanced-jdbc-wrapper to connect to Aurora databases. So I used that maven dependency, set the jdbc url to
jdbc:aws-wrapper:mysql://*
and the driver tosoftware.amazon.jdbc.Driver
.What did you expect to see?
I would expect that Flyway supports Aurora MySQL, since it is listed as a supported database here: https://documentation.red-gate.com/flyway/flyway-cli-and-api/supported-databases/aurora-mysql
But there is no flyway DatabaseType that supports jdbc urls like this one: "jdbc:aws-wrapper:mysql://*". So it is not possible to use flyway together with Aurora databases.
What did you see instead?
I get the exception
org.flywaydb.core.api.FlywayException: No database found to handle jdbc:aws-wrapper:mysql://
The text was updated successfully, but these errors were encountered: