HSQLDB: 3GB file, ~25 000 000 rows import!

[Imre Tokai]

Hello,

Pushing http://hsqldb.org/ to limits like noted in topic title and getting

Import summary ('#'-skips / rejects / inserts): 0 / 0 / 6237026.
Insertions will be lost if you don't commit.
SEVERE Rolling back SQL transaction.
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Unknown Source)
at java.lang.String.<init>(Unknown Source)
at java.lang.AbstractStringBuilder.substring(Unknown Source)
at java.lang.StringBuilder.substring(Unknown Source)
at java.lang.AbstractStringBuilder.subSequence(Unknown Source)
at java.lang.StringBuilder.subSequence(Unknown Source)
at java.util.regex.Matcher.getSubSequence(Unknown Source)
at java.util.regex.Matcher.group(Unknown Source)
at org.hsqldb.cmdline.sqltool.FileRecordReader.nextRecord(Unknown Source)
at org.hsqldb.cmdline.SqlFile.importDsv(Unknown Source)
at org.hsqldb.cmdline.SqlFile.processSpecial(Unknown Source)
at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)
at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)

hsqldb-import.sql

CREATE TABLE IF NOT EXISTS temp_3gb(field1 VARCHAR(255),field2 VARCHAR(255),field3 VARCHAR(255));
* *DSV_TARGET_TABLE = temp_3gb
* *DSV_COL_SPLITTER = ,
* *DSV_REJECT_FILE = d:/hsqldb/sample-reject.dsv
* *DSV_REJECT_REPORT = d:/hsqldb/sample-reject.html
\m d:/sampleFile3g.dsv
commit;

.rc file

#conn_testdb_file
urlid cfg_file
url jdbc:hsqldb:file:d:/hsqldb/testdb;hsqldb.large_data=true;hsqldb.cache_scale=18;hsqldb.cache_file_scale=8;hsqldb.cache_rows=10000;hsqldb.nio_data_file=false
username SA
password

Eclipse->Run Configurations->Arguments

-Xms2G -Xmx4G -XX:-UseGCOverheadLimit

It works as expected for 1000rows large file.
Any guidelines how to configure HSQLDB for 25 000 000 rows import? Have 16GB machine here.

Regards

PS
https://sourceforge.net/projects/hsqldb/forums/forum/73673/topic/8716091