TIL - Today I Learned

Getting

Table "databasechangelog" already exists;

after reusing database created with connection string:

jdbc:h2:~/testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE

Suggested by h2database official site to use MODE Postgres with DATABASE_TO_LOWER... but don't with liquibase.

New database created without lowering doesn't make problems

jdbc:h2:~/testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE;MODE=PostgreSQL