PIM on Quarkus 2.7.5 is failing to automatically create DB schemas through Flyway

After running some certification jobs for the DB certification matrix[1] we noticed that productization version of PIM for ER1 is failing, mainly because of the Quarkus version used to build PIM - 2.7.5.

After this upgrade, a new Flyway version is used (flyway-core 8.4.2), and in this one, some of the DBs are split in a different module such as MariaDB and MySQL (see note[2]) and thus a new dependency in the pom is needed.

And some others are not longer supported in Flyway community version like DB2, see exception below:

org.flywaydb.core.internal.license.FlywayEditionUpgradeRequiredException: Flyway Teams Edition or DB2 upgrade required: DB2 11.1 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition

Maybe, one option could be to replace flyway with sql-maven-plugin - as mmacik@redhat.com suggested me.

[1] - https://qe-jenkins-csb-business-automation.apps.ocp-c1.prod.psi.redhat.com/job/TESTING/job/7.13/job/RHPAM-CR/job/processes/job/certifications/job/pim-service-backend-db-matrix/1/

 [2] - https://flywaydb.org/documentation/learnmore/releaseNotes#8.2.1