Hi, I don't know what could be the problem. It looks like this file is missing... Are there any files in the directory \Users\Janni\picturedb.lobs.db? If not, was the database copied from somewhere else, and the directory picturedb.lobs.db wasn't? If this is not the problem, could you send me the database so I can analyze it?
Regards, Thomas On Mon, Oct 4, 2010 at 3:19 PM, Janni <[email protected]> wrote: > Hi, > > I get this Exception when I try to delete a row from an existing > table: > > org.h2.jdbc.JdbcSQLException: Fehler beim Umbenennen der Datei "C: > \Users\Janni\picturedb.lobs.db\13.t8.lob.db" nach "C:\Users\Janni > \picturedb.lobs.db\13.temp.lob.db" > Error while renaming file "C:\Users\Janni\picturedb.lobs.db > \13.t8.lob.db" to "C:\Users\Janni\picturedb.lobs.db > \13.temp.lob.db" [90024-141] > at org.h2.message.DbException.getJdbcSQLException(DbException.java: > 327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.store.fs.FileSystemDisk.rename(FileSystemDisk.java:104) > at org.h2.util.IOUtils.rename(IOUtils.java:650) > at org.h2.value.ValueLob.renameFile(ValueLob.java:740) > at org.h2.value.ValueLob.unlink(ValueLob.java:461) > at org.h2.engine.Session.commit(Session.java:502) > at org.h2.command.Command.stop(Command.java:168) > at org.h2.command.Command.executeUpdate(Command.java:244) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java: > 141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java: > 127) > > I used the Error Analyzer to find out whats wrong. And I am not sure > but it is possible that line 104 at FileSystemDisk.java is always > executed? Is it possible that the condition for this line is missing > or is it on purpose? > > I use PreparedStatement , executeUpdate() to insert, update and > delete data. Insert and update is working without exception, but I > always get this exception when I try to delete. > > I hope you can help me. > > Kind regards Janni > > -- > 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. > > -- 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.
