Hi, This is the error when i delete a entry. <https://lh3.googleusercontent.com/-GgteHuzawhU/Uuh_KvugrVI/AAAAAAAAABc/mqC8vf8Z1Ls/s1600/Untitled.jpg>
The stack trace is : 01-29 12:08:07 jdbc[3]: exception org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.FileNotFoundException: C:\Users\WeiRen\Documents\NetBeansProjects\DatabaseTrigger\H2\ICADB.lobs.db\36.lobs.db\9280.t3.lob.db (The system cannot find the path specified)" [90028-172] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:158) at org.h2.message.DbException.convertIOException(DbException.java:313) at org.h2.value.ValueLob.copyFileTo(ValueLob.java:777) at org.h2.value.ValueLob.link(ValueLob.java:515) at org.h2.index.PageDataIndex.add(PageDataIndex.java:118) at org.h2.table.RegularTable.addRow(RegularTable.java:124) at org.h2.engine.UndoLogRecord.undo(UndoLogRecord.java:112) at org.h2.engine.Session.rollbackTo(Session.java:557) at org.h2.command.Command.executeUpdate(Command.java:258) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:180) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) at com.solyp.sqldeveloper.client.E.B.B$_A.run(Unknown Source) Caused by: java.io.FileNotFoundException: C:\Users\WeiRen\Documents\NetBeansProjects\DatabaseTrigger\H2\ICADB.lobs.db\36.lobs.db\9280.t3.lob.db (The system cannot find the path specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(Unknown Source) at java.io.FileInputStream.<init>(Unknown Source) at org.h2.store.fs.FilePathDisk.newInputStream(FilePathDisk.java:307) at org.h2.store.fs.FileUtils.newInputStream(FileUtils.java:206) at org.h2.util.IOUtils.copyFiles(IOUtils.java:460) at org.h2.value.ValueLob.copyFileTo(ValueLob.java:775) Regards, Wei Ren 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 [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/groups/opt_out.
