Hello
We use H2 in our test framework and PG in production.
I am trying to migrate from 1.4.200 to 2.1.214 but getting sytax issues ,
while flyway 9 with spring 3.0.2 tries to execute the SQL queries on new H2.
I am getting following error, earlier with 2.1.214, same used to work with
1.4.200.
Please suggest, what config changes may be needed to make new H2 identify
these SQL queries?
{"@timestamp":"2023-02-24T20:35:49.094Z","service_name":"activate-inventory","level":"DEBUG","logger":"o.f.c.i.s.DefaultSqlScriptExecutor","thread":"main","message":"Executing
SQL:* create sequence hibernate_sequence start 1 increment 1*"}
.f.c.i.s.FlywaySqlScriptException: Migration V1__app_tables.sql
failed\n-----------------------------------\nSQL State : 42000\nError Code
: 42000\nMessage : Syntax error in SQL statement \
"create sequence hibernate_sequence [*]start 1 increment 1
Thanks
Hemant
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/af12b30f-d3cf-4df7-94fb-c9dbd186ca01n%40googlegroups.com.
