Hi All,
I have two db files x.h2(more than 1 GB) and x.h2.1.part (nearly 350 MB) created from my product line. I need to open the database. I am doing this by java -jar "jar file" and then the path to the 'x' database file. It gives me error saying corrupted file (File corrupted while reading record: "571899 of 524288". Possible solution: use the recovery tool [90030-174] <http://10.30.95.74:8082/login.do?jsessionid=18ef32b783147a165b58cc2c577f32ee#> 90030/90030 (Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90030>). I don't think this is corrupted as i have checked the checksum of files while copying. I tried opening it with java -cp option and getting the same error, mentioned below. Is there any way to open the db files keeping in mind we have two split files? Any help is highly appreciated. Exception in thread "main" org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "571899 of 524288" . Possible solution: use the recovery tool [90030-174] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) at org.h2.message.DbException.get(DbException.java:172) at org.h2.message.DbException.get(DbException.java:149) at org.h2.store.PageStore.readPage(PageStore.java:1288) at org.h2.store.PageStore.getPage(PageStore.java:738) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:232) at org.h2.index.PageDataNode.getLastKey(PageDataNode.java:213) at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:87) at org.h2.table.RegularTable.<init>(RegularTable.java:84) at org.h2.store.PageStore.openMetaIndex(PageStore.java:1570) at org.h2.store.PageStore.recover(PageStore.java:1369) at org.h2.store.PageStore.openExisting(PageStore.java:361) at org.h2.store.PageStore.open(PageStore.java:285) at org.h2.engine.Database.getPageStore(Database.java:2277) at org.h2.engine.Database.open(Database.java:610) at org.h2.engine.Database.openDatabase(Database.java:236) at org.h2.engine.Database.<init>(Database.java:231) at org.h2.engine.Engine.openSession(Engine.java:56) at org.h2.engine.Engine.openSession(Engine.java:160) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139) at org.h2.engine.Engine.createSession(Engine.java:122) at org.h2.engine.Engine.createSession(Engine.java:28) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) at org.h2.Driver.connect(Driver.java:73) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.h2.tools.RunScript.process(RunScript.java:314) at org.h2.tools.RunScript.runTool(RunScript.java:142) at org.h2.tools.RunScript.main(RunScript.java:69) Thanks in advance, Vineet -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
