Quantcast

Load Data into HSQLDB

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Load Data into HSQLDB

kushal bansal
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Load Data into HSQLDB

Fred Toussi-2
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"
<[hidden email]> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
Loading...