Hello, I have a problem running Liquibase with Maven + Spring Boot. The following occurs:
I have two schemas, schema1 and schema2. In the project, I have 3 native SQL scripts: first create the two schema, then create the tables and third populate the data.
But whenever I make a mvn clean install
and then java -jar projeto-x-0.0.1.jar
it says in the logs that the schemas already exist. Even if you get the sql that creates the schemas first, the second script (which creates the tables) also gives error.
I would like to know how to do it so that when I upload the project, I would not execute the same changesets that were already executed the first time. (obs: the two tables of liquibase, databasechangelog and databasechangeloglock, are being created in public schema)
OBS : I found the cause: When I first upload, it creates the databasechangelog and databasechangeloglock tables in public. But then when I go up the second time it creates in schema1. Does anyone know how to solve this problem?