Support HSQLDB or add samples on how to automate Integration Testing with SpringBoot and Flyway

[maxsap]

I have been trying to setup automatic integration testing using flyway and Javers but I have not found any proper way to do so, looking into your tests is not really helping since the coverage on the SQL part is non-existing pretty much.
This is partially due to H2 which does not offer any elegant way to truncate the rows of the DB.

So my suggestion would be to either allow controlling the Javers schema externally, or support hsqldb, or provide some sample on how a proper integration test is supposed to be.

[bartoszwalacik]

OK, so what kind of feature you need?

posibility to clean JaversRepository or posibillity to control the Javers schema externally
(we already have the issue for the latter #542)

[maxsap]

Well, the schema definitely since this should be controlled from Flyway or some other equivalent tool.
Cleaning the JaversRepository as long as it validates the schema on start.
i.e. given that the schema can be controlled externally, this means that the repo needs to be up to date with the changes.

[bartoszwalacik]

closing due to lack of activity