Is it not an option to simply split up the script into multiple files with around 265,000 querys in each?
2010/2/16 uyeee <toomoko.uey...@gmail.com>: > Thank you Chuck > > I download from here > http://www.h2database.com/h2-2010-01-30.zip > > I used "org.h2.tools.RunScript". > > jvm option > -Xms5120m -Xmx5120m > > command line option > -url "jdbc:h2:http:localhost/ > test;SCHEMA=test;LOCK_MODE=0;LOG=0;UNDO_LOG=0" > -driver "org.h2.Driver" > -user sa > -script test.sql > > --------------------------------- > test.sql > insert into test (c1,c2,c3,c4,c5,c6) values > ('a1','','b1','c1','d1','e1'); > insert into test (c1,c2,c3,c4,c5,c6) values > ('a2','','b2','c2','d2','e2'); > insert into test (c1,c2,c3,c4,c5,c6) values > ('a3','','b3','c3','d3','e3'); > : > : > ---------------------------------- > > but it stopped at 268,096 recode. > > I see ,It caused by less memory. > > Then, I should use more memory?? > Or, I should use other tools?? > > よろしくおねがいします! > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to h2-datab...@googlegroups.com. > To unsubscribe from this group, send email to > h2-database+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
