RIght now I have a cuba application which is using hsql databasae each time the app starts, Now I want to migrate to postgres DB from hsql. When I try to connect to postgres isntance, I am getting below error. Any tips on this would be greatly appreciated
:cuba-reports-core:assembleDbScripts UP-TO-DATE
:cuba-reports-core:updateDb
Table SYS_DB_CHANGELOG does not exist, running all init scripts
May 30, 2024 10:59:12 AM groovy.sql.Sql executeUpdate
WARNING: Failed to execute: create table SYS_DB_CHANGELOG (SCRIPT_NAME varchar(300) not null primary key, CREATE_TS null default current_timestamp, IS_INIT integer default 0) because: ERROR: syntax error at or near “null”
Position: 89
:cuba-reports-core:updateDb FAILED
FAILURE: Build failed with an exception.
- What went wrong:
Execution failed for task ‘:cuba-reports-core:updateDb’.
org.postgresql.util.PSQLException: ERROR: syntax error at or near “null”
Position: 89
- Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.
BUILD FAILED
Total time: 1.913 secs
[10:59:13.021] Task ‘updateDb, deploy, start’ failed
org.postgresql.util.PSQLException: ERROR: syntax error at or near “null”
Position: 89
When I looked at the code, looks like the above error is coming from DbUpdaterEngine.java from cuba-core 6.5.7