Hi, there are files existing in the directory \Users\Janni \picturedb.lobs.db Maybe I copied the db a while ago, I cant say for sure. I tried to create a new db for my program and I dont know why but it works, no problems with deleting at all. So I guess it was my fault..
Thank you for your help Kind regards Janni On 7 Okt., 23:18, Thomas Mueller <[email protected]> wrote: > 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 > > athttp://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.
