Hi, > [90124-118]
You are actually using an older version in this case: the 118 in the error code is the build number. In this case it is version 1.1.118 I believe. What I would do is create an empty files with this name, or manually remove the statement in the script file. To do that automatically, I guess the best solution is to patch the script tool to automatically continue on error. Newer versions of H2 support this feature I believe. Regards, Thomas On Mon, Oct 1, 2012 at 10:20 AM, sascha <[email protected]> wrote: > 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. > -- 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.
