Hi,
I can't post the result of SCRIPT NODATA, because the schema of database is
secret part of my project. I have about 35 tables, with about 5 to 20
columns in it, the bigest size of column is varchar(2000), but it is the
only one, for other strings I use varchar(255). In this database I have two
tables which are the bigest: one has 25 000 rows of data, and second 280 000
.
I run script command from windows commandline:
D:\Programs\H2\bin>java -cp h2*.jar org.h2.tools.Script -url
"jdbc:h2:C:\\path2db\myDB" -user "user" -password "secret" -script
"c:\\backup.sql"
and the result is:
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at org.h2.value.Value.cache(Value.java:335)
at org.h2.value.ValueString.get(ValueString.java:91)
at org.h2.store.DataPage.readValue(DataPage.java:623)
at org.h2.table.TableData.readRow(TableData.java:599)
at org.h2.table.TableData.read(TableData.java:586)
at org.h2.store.DiskFile.getRecord(DiskFile.java:607)
at org.h2.store.Storage.getRecord(Storage.java:94)
at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:253)
at org.h2.index.ScanCursor.next(ScanCursor.java:71)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:258)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQueryLocal(Command.java:141)
at org.h2.command.Command.executeQuery(Command.java:122)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at org.h2.tools.Script.process(Script.java:158)
at org.h2.tools.Script.run(Script.java:109)
at org.h2.tools.Script.main(Script.java:57)
My solution is of course to use more java heap space:
java -Xmx1024m -cp h2*.jar org.h2.tools.Script -url
"jdbc:h2:C:\\path2db\myDB" -user "user" -password "secret" -script
"c:\\backup.sql"
I've tried to script this database from H2 console:
SCRIPT SIMPLE TO 'aaaa.sql'
It works OK :)
2009/6/1 Thomas Mueller <[email protected]>
>
> Hi,
>
> Do you have very large VARCHAR or BINARY columns in your database? If
> yes I suggest to use CLOB or BLOB instead. Could you post the result
> of SCRIPT NODATA?
>
> Did you try with the options described in
> http://www.h2database.com/javadoc/org/h2/tools/Script.html#main(String[])<http://www.h2database.com/javadoc/org/h2/tools/Script.html#main%28String%5B%5D%29>
> and http://www.h2database.com/html/grammar.html#script ?
>
> Regards,
> Thomas
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
