Not able to execute TRUNCATE statement on HSQL in-memory DB

1.2k Views Asked by At

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]
0

There are 0 best solutions below