Hibernate Community • View topic - locking on a subclass table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

locking on a subclass table

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

eranl

Post subject: locking on a subclass table

Posted: Thu Jul 15, 2004 9:57 pm

Newbie

Joined: Thu Jul 15, 2004 9:08 pm
Posts: 1

I need to call

Code:

session.refresh(this, LockMode.UPGRADE);

in order to write to a CLOB column in my subclass table (I'm using an Oracle DB, so I have to use this http://www.hibernate.org/56.html workaround). However, the generated SQL is

Code:

select <id column> from <root table> where <id column>=? and VERSION =? for update

which only locks the the root table, so my CLOB write fails with:

Code:

java.io.IOException: ORA-22920: row containing the LOB value is not locked

Did I miss something here?

Thanks.
Eran

(Hibernate version: 2.1)

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum