I am using HSQL in-memory DB for test cases,which will execute
TRUNCATE TABLE TABLE_NAME IGNORE DELETE TRIGGERS DROP STORAGE IMMEDIATE
Below error encountering when running the test case.
StatementCallback; bad SQL grammar [TRUNCATE TABLE TABLE_NAME];
nested exception is java.sql.SQLException: Unexpected token: TRUNCATE in statement [TRUNCATE]