You ran out of Java heap space. You don't show any of your code, but this is clearly not a problem with H2. Your code is holding references to a lot of data and used up all of the memory. I can see that from the backtrace.
Show us more code so we can suggest how to manage your memory better. Or, allocate more RAM to your JVM (-Xmx6g or larger). cr On Feb 15, 2010, at 7:52 AM, uyeee wrote: > Hi! > > I use runscript(org.h2.tools.RunScript). > > java -Xms5120m -Xmx5120m LOCK_MODE=0;LOG=0;UNDO_LOG=0 > > > when 268,096 recode inserted, it stoped... > > please tell me how insert more data. > > よろしくおねがいします! > > > this is Exception message > --------------------------------------------------------------------------------------------------------------------- > Exception in thread "main" java.lang.OutOfMemoryError: Java heap space > at java.util.Arrays.copyOf(Arrays.java:2882) > at > java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java: > 100) > at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java: > 390) > at java.lang.StringBuffer.append(StringBuffer.java:224) > at java.text.MessageFormat.subformat(MessageFormat.java:1208) > at java.text.MessageFormat.format(MessageFormat.java:836) > at java.text.Format.format(Format.java:140) > at java.text.MessageFormat.format(MessageFormat.java:812) > at org.h2.message.Message.translate(Message.java:94) > at org.h2.message.Message.getSQLException(Message.java:109) > at org.h2.message.Message.getSQLException(Message.java:121) > at org.h2.message.Message.getSyntaxError(Message.java:146) > at org.h2.command.Parser.read(Parser.java:2558) > at org.h2.command.Parser.readIfMore(Parser.java:775) > at org.h2.command.Parser.parseInsert(Parser.java:951) > at org.h2.command.Parser.parsePrepared(Parser.java:379) > at org.h2.command.Parser.parse(Parser.java:292) > at org.h2.command.Parser.parse(Parser.java:264) > at org.h2.command.Parser.prepareCommand(Parser.java:236) > at org.h2.engine.Session.prepareLocal(Session.java:417) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:231) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) > at java.lang.Thread.run(Thread.java:619) > > at org.h2.engine.SessionRemote.done(SessionRemote.java:522) > at org.h2.command.CommandRemote.prepare(CommandRemote.java:70) > at org.h2.command.CommandRemote.<init>(CommandRemote.java:48) > at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:418) > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java: > 1070) > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151) > at org.h2.tools.RunScript.process(RunScript.java:250) > at org.h2.tools.RunScript.process(RunScript.java:186) > at org.h2.tools.RunScript.process(RunScript.java:311) > at org.h2.tools.RunScript.run(RunScript.java:140) > at org.h2.tools.RunScript.main(RunScript.java:68) > > -- > 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.
