Hello,

I'm using h2 in my project and I've been able to export my data to sql 
without issues until today. On a client database I have this exception when 
trying to export the database to sql.

Here is the exception for reference.
 java -cp ~/.m2/repository/com/h2database/h2/1.3.168/h2-1.3.168.jar 
org.h2.tools.Script -url "jdbc:h2:~/db" -user "sa" -script "~/backup.sql"
Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error: 
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SCRIPT [50000-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convert(DbException.java:281)
at org.h2.command.Command.executeQuery(Command.java:195)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at org.h2.tools.Script.process(Script.java:172)
at org.h2.tools.Script.execute(Script.java:153)
at org.h2.tools.Script.execute(Script.java:133)
at org.h2.tools.Script.runTool(Script.java:101)
at org.h2.tools.Script.main(Script.java:51)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:295)
at org.h2.command.CommandContainer.query(CommandContainer.java:86)
at org.h2.command.Command.executeQuery(Command.java:191)
... 6 more

I can still read and write on the database without issues but the script 
export won't work. Is there anything I can do?
I've already tried to run the command against different h2  versions 
1.2.128, 1.2.147 and 1.3.168 but all generate the same exceptions

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/8NGAFym8vhMJ.
To post to this group, send email to h2-database@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.

Reply via email to