Then I provided URL as : jdbc:hsqldb:file:E:\test\testdb. and hit on enter
I created a sample cached table to load records into it. To load records I selected 'Open script' from UI and tried to give path of a .sql file with 100k 'Insert into' statements. I see that when I try to load lesser number of records like 20k I succeed. But when I try to insert 100K+ records I am not able to do that.
I even tried changing the .script file with the following
SET FILES CACHE SIZE 1000000
SET FILES CACHE ROWS 1000000
SET FILES SCALE 16