Hibernate LockMode

dgranzotto · **Joined:** Thu Mar 04, 2004 3:55 pm **Posts:** 8

Hibernate version: 3.0

Name and version of the database you are using: Firebird 1.5.1 on Windows 2000

Hi,

I want to get and lock a record using
session.get(Item, LockMode.UPGRADE)

even so, if I start my application in
other machine on net,
I can read the Item that should be locked.

Should not this impede the reading of this Item?

Thanks,

Douglas Granzotto
Lages/SC - Brazil

christian · **Posted:** Wed Sep 29, 2004 6:33 pm

No, this is a row level exclusive lock (in Oracle), preventing concurrent writes. Check your database documentation for the behavior of "select ... for update".

dgranzotto · **Joined:** Thu Mar 04, 2004 3:55 pm **Posts:** 8

is there an way to impede the reading of an record while it is updated ?

christian · **Posted:** Wed Sep 29, 2004 9:47 pm

Check the Oracle documentation, what you need is probably a session.connection().createStatement("lock table foo in share mode") or something similar. This will kill your performance and have a real impact on scalability, of course. Make sure you understand what you are doing.