Project

General

Profile

Liquibase with H2 database in PostgreSQL MODE

Added by Komorek, Kamil 7 months ago

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


Comments