I have configured HSQL DB (v 2.2.9) and using it for Junit testing purpose. I have configured the following in the application context:
Whenever I'm executing a SQL select I'm getting the below exception:
I'm able to execute the same query in SQL developer without any errors and I confirmed it multiple times. I've created the HSQL schema for all the tables like this:
I've also executed the scripts for inserting the constants data. But I'm stuck up with this issue for a long time. Can you please help me out on this issue?
Really appreciate your help.