Forgot to mention, 30 is the split size and that can vary. On Thursday, 14 August 2014 10:15:12 UTC+5:30, Vineet wrote: > > Thanks every one for replying on this thread. I think I found what I need > to do: > You should be knowing the split size of the DB you are dealing with. > > for example if your split size of your DB is 1GB then the URL you need > is jdbc:h2:split:30:<path to database> > > Thanks > > > On Tuesday, 12 August 2014 13:26:08 UTC+5:30, Vineet wrote: >> >> 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.
