Thanks a lot for the caveat on LOBS and MVCC. I will consider other alternatives for the moment.
(reference to new storage engine: MVStore<http://www.h2database.com/html/mvstore.html> ) Am Montag, 24. Juni 2013 11:29:12 UTC+2 schrieb Kartweel: > > Hi, > > Yeah this doesn't work. And nobody is currently supporting MVCC until the > new Storage engine is out. So options are: Don't use MVCC. Don't use For > Update with LOBS. Try and fix H2 code. > > Also, Other people have noted problems with lots of LOBS and MVCC when not > using for update. > > Ryan > > > On 24/06/2013 4:20 PM, Juan Miguel Cejuela wrote: > > I'm getting the following error: > > org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: > org.h2.message.DbException: IO Exception: ""java.io.IOException: > org.h2.jdbc.JdbcSQLException: IO Exception: """"Missing lob: 7"""" > [90028-170]"" [90028-168]"; "lob: null table: -1 id: 7" [90031-168] > > > When I do a select for update of a row with a CLOB column. > > Facts: > > - I added the CLOB column to an existing table. > - The table and the database were created with h2 version 168. > - The server is currently using h2 version 172. > - I use MVCC > - If I do a normal select (without for update), it works fine. > > > What is the cause of the error and how can I solve it? > Should I drop the MVCC setting? (although I want it...) > -- > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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 [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.
