Liquibase and JOOQ

Important Notices

• IMPORTANT: Please note that these are the steps I take to make everything consistently work even though it should not all be required. Once the related issues are resolved we need to update this wiki page.
• IMPORTANT: At this time all JOOQ generated code is suppose to be committed into the repository.

Updating Liquibase

• IMPORTANT: The server should be SHUTDOWN while you perform these steps.

Simple Update

• liquibase::update

If you are just doing a simple update with the latest changelogs then you can run liquibase::update in Maven and your database should be updated.

Debugging

• liquibase::dropAll
• liquibase::clearCheckSums
• liquibase::update

If you are debugging and need to reset everything then it can get more complicated. In this case you need to run the above three Maven commands in order every time. The first liquibase::dropAll is to delete the contents of the database. Then you need to use liquibase::clearCheckSums so that there are no conflicts with the changeset id number. This step is very important because if you are debugging then you will most likely be using the same changeset id as you debug. And lastly you need to update the database with liquibase::update