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.
