Hi,

I am newbie to HSQLDB. I am using HSQLDB 2.1 in file mode. I used the command to launch the UI

java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

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

still no success. Kindly help. Thanks in advance.



------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today.  Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@list...
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers