Hi, It looks like H2 now needs more heap space than it used to, specially when creating tables. I will have to fix the memory usage methods.
Could you send me the backup_script.ZIP? Regards, Thomas On Fri, Feb 5, 2010 at 4:17 AM, Ryan How <[email protected]> wrote: > Hi, > > I've switched over to the new page store, version 1.2.128. I haven't done > tests, but a lot of things appear to be faster than before which is nice > (and database size is much smaller!!) > > Anyway, my issue is related to the SCRIPT TO command. I am running out of > heap space and it seems to use a lot of memory. > > This is my code. > > Class.forName("org.h2.Driver"); > Connection conn = > DriverManager.getConnection("jdbc:h2:file:db/db", "sa", "sa"); > Statement s = conn.createStatement(); > s.execute("SCRIPT DROP TO 'backup/backup_script.ZIP' COMPRESSION > ZIP"); > conn.close(); > > > I'm executing it with > > java -Xmx256m -classpath "h2.jar;" utils.ScriptDb > > and this is the stack trace > > Exception in thread "main" java.lang.OutOfMemoryError: Java heap space > at java.util.Arrays.copyOf(Unknown Source) > at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source) > at java.lang.AbstractStringBuilder.append(Unknown Source) > at java.lang.StringBuilder.append(Unknown Source) > at org.h2.command.dml.ScriptCommand.add(ScriptCommand.java:532) > at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:270) > at org.h2.command.CommandContainer.query(CommandContainer.java:81) > at org.h2.command.Command.executeQuery(Command.java:132) > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:172) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151) > at utils.ScriptDb.main(ScriptDb.java:31) > > > > And my database is 208MB in size, containing 2 tables. > > I can just increase the heap size, but it seems like a LOT just to dump the > database. I expected it would have taken a few MB if that... > > And when this database grows to a few GB, I don't think the heap will go > that big :) > > Am I missing anything? > > > Cheers, > > Ryan > > > > > > -- > 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. > > -- 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.
