Hi, > org.h2.jdbc.JdbcSQLException: User XIAM already exists; SQL statement: > CREATE USER XIAM SALT '232b01e2e43cdda0' HASH
> We 're using H2 together with a Jetty server, and I think the database > got corrupted when restarting Jetty. Yes, it looks like. > Unfortunately, some data has been lost in the process. Because it was > a test environment, it was not that important. But we don 't want > these things to happen in production :) Of course that's not acceptable. > is there any way to prevent these errors from happening > in the future? Upgrade to version 1.1.108 (2009-02-28). In this version, a bug was fixed that could have caused this problem. See also http://www.h2database.com/html/changelog.html "When the shutdown hook closed the database, the last log file was deleted too early." > And second, is it possible to resolve from these errors, and keep > using the H2 database? Usually the Recover tool can recover all the data stored in the database. See http://www.h2database.com/javadoc/org/h2/tools/Recover.html#main(String[]) 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 -~----------~----~----~----~------~----~------~--~---
