Define schema

[faeb5]

Hi, is it possible to specify a default schema that will be used to clean and migrate the database? I'm writing unit tests in a Quarkus project using a H2 database. All of the entities are configured to use a certain database schema.

However, in the test logs I can see that all the clean and migrate scripts are executed using the default schema of the database (which is called PUBLIC and not my database schema).

A possible workaround for the migration scripts is to add the line SET SCHEMA MYSCHEMA at the beginning of the SQL script, but the clean method after each test will not work because it tries to clean the wrong schema.

Is there a way to specify the used database schema?

[radcortez]

I believe this can be done by setting the default schema used by Flyway:
https://flywaydb.org/documentation/configuration/parameters/defaultSchema

I didn't try, but the extension should read the flyway configuration file or environment variables. Can you try it and let me know if this works for you?