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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
