On 25 mayo, 16:23, María Arias de Reyna <[email protected]> wrote:
> > If I run the recovery tool and then
> > do a runscript, the database will be recovered?
>
> Anyway, I tried this and the recovery tool doesn't work well. It
> extracts the data on a wrong order, making the runscript fail because
> it tries to add data before the foreign keys are fully inserted on
> their referenced tables.
>
> Table A has a foreign key referencing Table B
> The RunScript tries to add the data on table A before adding the data
> on table B, so it fails (the foreign key doesn't have a proper
> reference).
It also fails trying to add the "sa" user, which I also think is a
bug.
Exception in thread "main" org.h2.jdbc.JdbcSQLException: User SA
already exists [90033-100]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.command.ddl.CreateUser.update(CreateUser.java:69)
at org.h2.command.CommandContainer.update
(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:206)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:
283)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:127)
at java.lang.Thread.run(Thread.java:595)
at org.h2.engine.SessionRemote.done(SessionRemote.java:493)
at org.h2.command.CommandRemote.executeUpdate
(CommandRemote.java:192)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:163)
at org.h2.tools.RunScript.process(RunScript.java:227)
at org.h2.tools.RunScript.process(RunScript.java:198)
at org.h2.tools.RunScript.process(RunScript.java:324)
at org.h2.tools.RunScript.run(RunScript.java:151)
at org.h2.tools.RunScript.main(RunScript.java:94)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
