How to alter databasechangelog.filename for Spring Boot and Liquibase?

Question

I'm using Spring Boot 2.0.1 and liquibase-core-3.5.5.

When I run the application from IntelliJ (which will run the main() method) I see the following type of value in the Liquibase database column database.filename:

db/changelog/changes/v0001.sql

If I create a fat jar with embedded Tomcat and run the application, the same changeset will appear in the database as:

BOOT-INF/classes/db/changelog/changes/v0001.sql

I would like these values to match so that I can run my applications as JAR files, but connect to a remote database from IntelliJ if debugging is necessary. (Note: this would be for a test database, I would not debug production in this way).

I have found references to logicalFilePath (such as this SO question), but I don't believe this will provide what I need.

I have also tried debugging into the Liquibase code to determine if there is a way I can alter this value. The closest I've come is these two observations:

1. The absolute file path of the SQL file trimmed to its final value here.
2. The full set of changes being persisted is available here. And if I change one of those values (while debugging), I can see that it makes it into the database.

If there is a way to make these consistent, or possibly just change the filename column to the actual filename (e.g. v0001.sql), that would be best.

UPDATE

I have Liquibase setup as the following in Spring Boot:

My resources/db/changelog/db.changelog-master.yaml file has the following contents:

databaseChangeLog:
    - includeAll:
        path: db/changelog/changes/

And then in resources/db/changelog/changes I have individual *.sql files that contain the SQL I want to run. I do not recall where I found this setup, but I don't have anything specific to "changesets", is this an error on my part?

Answer 1

I was able to use this by no longer using the includeAll option in my db.changelog-master.yaml file. The includeAll option is a helpful way to get started quickly (and process all files in a specific directory), but it seems to be unadvisable for regular use. As mentioned here (as of July 2024 that link no longer mentions that includeAll should be avoided).

This is what I previously had in db.changelog-master.yaml, don't use it this way.

databaseChangeLog:
    - includeAll:
        path: db/changelog/changes/

This is what I updated it to:

databaseChangeLog:
    - include:
        file: db/changelog/changes/v0001_users.sql
    - include:
        file: db/changelog/changes/v0002_accounts.sql

The important thing to note is that I'm specifically listing every single file that I want included, in the order I want it run. This is a little bit of a hassle, but well worth the change.

In the original version, the databasechangelog.filename column would be different based on how the application was executed:

• db/changelog/changes/v0001_users.sql is how the column would appear when running from IntelliJ
• BOOT-INF/classes/db/changelog/changes/v0001_users.sql is how the column would appear when running from an executable jar.

After making the change, both options above are the same, and no longer include BOOT-INF/classes/ as a prefix.

Thanks to the other answers that helped point me in the correct direction!