search

devonfw / devon4j

devonfw Java stack - create enterprise-grade business apps in Java safe and fast
Apache License 2.0
83 stars 87 forks source link

Consider liquibase #303

Open hohwille opened 4 years ago

hohwille commented 4 years ago

We are aiming to propose a main default suggestion for every problem and therefore have our key-principles. Following KISS we have choosen flywaydb for DB versioning as it is simple and you typically just put your SQL files as you would manually run them on your DB.

A famous alternative to flyway is liquibase that allows some DB abstraction. This is typically not needed as most projects have one supported DB to run on. However, flyway removed some features as support for specific Oracle versions and caused some severe issues to our projects in production forcing them to buy a commercial license. While it is OK for commecial projects to buy a commercial license, it was surprising that an OSS edition removed support in a newer version. In this case several users requested liquibase support. As we do not want to drop and replace flyway with liquibase we should consider adding liquibase as a supported option.

To summarize this story:

hohwille commented 3 years ago

Rationale that can be added to the documentation:

[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.5.3:clean (default-cli) on project demo-core: org.flywaydb.core.internal.license.FlywayTeamsUpgradeRequiredException: Flyway Teams Edition upgrade required: oracle.sqlplus is not supported by Flyway Community Edition. -> [Help 1]

or

org.flywaydb.core.internal.license.FlywayEnterpriseUpgradeRequiredException: Flyway Enterprise Edition or Oracle upgrade required: Oracle 11.2 is past regular support by Oracle and no longer supported by Flyway Community Edition, but still supported by Flyway Enterprise Edition.
baumeister25 commented 2 years ago

@hohwille @dixyushi Is there any progress on this story? Do you need support?