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 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/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/groups/opt_out.