Hibernate Community • View topic - locking and unlocking entry in Database table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

locking and unlocking entry in Database table

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

antoschka

Post subject: locking and unlocking entry in Database table

Posted: Wed Apr 02, 2008 11:03 am

Beginner

Joined: Tue Jan 22, 2008 11:33 am
Posts: 46

Hi,

writing an multi-client application I need to lock (& unlock) one or more entries of a table, so other user will not change the entry in the meantime. Is there way to do that with NHibernate. If so, how would I do that?

thanks for your help

antoschka

Top

antoschka

Post subject:

Posted: Fri Apr 04, 2008 3:31 am

Beginner

Joined: Tue Jan 22, 2008 11:33 am
Posts: 46

Nobody an idea?

Top

FlukeFan

Post subject: locking and unlocking entry in Database table

Posted: Fri Apr 04, 2008 4:56 am

Senior

Joined: Thu Jun 21, 2007 8:03 am
Posts: 127
Location: UK

Hi antoschka,

If it's an online lock you're after (i.e., lock an object for the duration of a transaction) then you can upgrade the lock when loading an object:

Code:

MyObject myObject = session.Get<MyObject>(11, LockMode.Upgrade);

http://forum.hibernate.org/viewtopic.php?t=985090
http://www.hibernate.org/hib_docs/nhibernate/html_single/#transactions-locking

If it's an offline lock you're after you could look at versioning:
http://www.hibernate.org/hib_docs/nhibernate/html_single/#transactions-optimistic-manual

Regards,
Richard

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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