Hi, The file for the LOB object was not found. This can have multiple reasons, for example a bug in the database engine, or the file was removed or not restored on the file system.
Since quite a long time, H2 no longer stores LOB objects in separate files by default. One of the reasons is to avoid the exception you got. I'm afraid I can't give you back the missing file, but I suggest to use the default settings, which is to not use external files for LOB objects. In future versions of H2, this will no longer be supported. If you have an old database, please export it to a SQL script and then re-create the database. Regards, Thomas On Monday, February 3, 2014, Vonmist <kwa...@gmail.com> wrote: > Does anyone know how to solve this problem? Thanks > > On Tuesday, January 28, 2014 12:14:04 PM UTC+8, Vonmist wrote: >> >> Hi, i have created a Trigger on a specific database and it will insert >> data into another database once a trigger is invoked. This is working fine >> using java but if i were to delete the record at that database with the >> trigger manually, the trigger was not invoked. Is there any ways i can make >> it works? >> >> When i did a manual delete using SQL Developer tools, i have this error: >> IO EXCEPTION " java.io.FIleNotFoundException: path to my >> database\databaseName.los.db\36.lobs.db\9341.t3.lob.db. >> >> In my folder which contain the database, i don't have any file with >> lob.db. >> Help please! Thanks >> > -- > 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 > h2-database+unsubscr...@googlegroups.com<javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to > h2-database@googlegroups.com<javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
