Please use CREATE CACHED TABLE, or for an existing table, SET TABLE name TYPE CACHED.
See the guide on different table types. Please post any future questions to the hsqldb-user mailing list. Fred On Tue, 26 Apr 2011 17:09 -0700, "kushal bansal" <kushalban...@yahoo.com> wrote: > 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 > ------------------------------------------------------------------------------ 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
