Changeset sqlFile path problem for spring boot

Community Answers
1

liquibase verstion: Liquibase Community 4.3.5

change set:

<changeSet id="1623941321260_add_functions_calculateStage_and_checkIfPracticeComplete" author="Lu, Xinghe">
        <sqlFile encoding="utf8" dbms="mysql" path="/src/main/resources/db/changelog/sql/1623941321260_add_functions_calculateStage_and_checkIfPracticeComplete_by_xinghe.up.sql"
                 splitStatements="true"
                  stripComments="true"
                 endDelimiter="//" />
        <rollback>
            <sqlFile encoding="utf8" dbms="mysql" path="/src/main/resources/db/changelog/sql/1623941321260_add_functions_calculateStage_and_checkIfPracticeComplete_by_xinghe.down.sql"
                     splitStatements="true"
                      stripComments="true"
                     />
        </rollback>
    </changeSet>

this works if I run goal: mvn liquibase:update; but failed when I tried to start the spring boot app.

here is the error message:
Caused by: java.io.IOException: The file /src/main/resources/db/changelog/sql/1623941321260_add_functions_calculateStage_and_checkIfPracticeComplete_by_xinghe.up.sql was not found in
Specifying files by absolute path was removed in Liquibase 4.0. Please use a relative path or add ‘/’ to the classpath parameter.

This is really frustrating, hope someone can help.

2

Hi @lxinghe

This seems like a bug till Liquibase version 4.3.5 and has been fixed in version 4.4.0

Please have a look at the discussion on this created issue.

Please try and upgrade your Liquibae version to 4.4.0 and check once.

Please do share the results.

Thanks!
Rakhi Agrawal

3

Hello @rakhi,
Thanks so much for helping me T.T I will try it right away.

Sincerely
Xinghe

4

Happy to help!

Awaiting the results :slight_smile: