I got the following error very often during data import:

Error: org.h2.jdbc.JdbcSQLException: Out of memory. [90108-154]

My db url:

jdbc:h2:tcp://localhost/split:32:~/h2data/sc_file.db;PAGE_SIZE=16384;CACHE_SIZE=8388608

and
I started import with the following:
SET TRACE_LEVEL_FILE 2;
SET UNDO_LOG 0;
SET LOG 0;
SET LOCK_MODE 0;

inert into testtab
select * from ....


The table has 34 columns.

DB got lock when the import was executing. I can't create any session.

Any idea please.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to