Hi I searched this group for a solution to my problem, but couldn't find anything. Hope I didn't just miss it. If so, my apologies.
We are using H2 for many years now in our consumer product; currently we are using V1.2.123 (which is quite old and we are planning to update to a newer version). Every now and then we are seeing users having problems with missing LOB-Files in their database. This problem usually shows when we have to migrate the data from one version of our software to a newer version. We do this by creating a SQL-Dump that then is imported into an new database which then gets migrated. Now in some cases the dump file cannot be imported because of a FileNotFoundException for one or more LOB-Files: File not found: D:\Project\websites\Kunden\xxx\data\data.lobs.db\6.t225.lob.db; SQL statement: SCRIPT [90124-118] This also happens when we try to import the dump of a Db that is corrupted in this way via runscript from the H2 Console. We have also tried the repair-Tool, which leads to the same result: the file causes an exception when we try to import it via runscript in the H2 Console. Now my question: is there a way to "repair" the Database, e.g. by just ignoring the missing LOB-Data? (Loosing some data is still better than having a database that is completely unusable since it cannot be recreated from a dump.) Many thanks in advance for any help. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/FmPcrQ-oj4wJ. 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.
