I’ve setup liquibase to work with my project that connects to a SQL Hana DB but for some reason i get this
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near “current_schema”: line 1 col 6 (at pos 6)
My changelog are setup right, but i dont want to set the current schema as it might change from customer to customer.
It seems to be connecting to the right database as a bit later i got this
2021-09-01T20:38:06.082+0000 [APP/PROC/WEB/0] OUT org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘liquibase’ defined in com.eir.spring.SpringConfig: Invocation of init method failed; nested exception is liquibase.exception.DatabaseException: SAP DBTech JDBC: [288] (at 13): cannot use duplicate table name: DATABASECHANGELOG: line 1 col 14 (at pos 13) [Failed SQL: CREATE TABLE DATABASECHANGELOG (ID NVARCHAR(255) NOT NULL, AUTHOR NVARCHAR(255) NOT NULL, FILENAME NVARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE NVARCHAR(10) NOT NULL, MD5SUM NVARCHAR(35), DESCRIPTION NVARCHAR(255), COMMENTS NVARCHAR(255), TAG NVARCHAR(255), LIQUIBASE NVARCHAR(20), CONTEXTS NVARCHAR(255), LABELS NVARCHAR(255), DEPLOYMENT_ID NVARCHAR(10))]
I can see this table in my database
any help would be appreciated