immediate lock after read (Select for update)

mk14 · **Joined:** Wed Oct 20, 2010 6:17 am **Posts:** 4

Hello,

i want to read a object out of the database and lock it while/ immediate after reading.
I only found this way:

Code:

session.lock(object, lockMode)

and of course HQL.
Unfortunately, both are NOT compatible with my application design, cause i read with the aid of logics.

Now i'm looking for a solution like the following :

Code:

ArticleLogic al = new ArticleLogic();
al.setFilter(ArticleLogic.FILTER_SERIAL_NUMBER, "123456");
al.setFilter(ArticleLogic.FILTER_LOCK, true);

Article tempArticle = al.unique();

tempArticle.setStatus("reserved");

session.update(tempArticle);

It should produce a SQL statement like this:

SELECT * FROM article WITH (UPDLOCK) WHERE serial_number = '123456'

The selected record should immediate gets locked.

I hope someone recognize my need and help me out.

Thanks and regards,

MK

r · **Joined:** Fri Oct 08, 2010 8:44 am **Posts:** 130

Try to use LockMode.UPGRADE

mk14 · **Joined:** Wed Oct 20, 2010 6:17 am **Posts:** 4

Hello,

i found a way with the aid of the Criteria API.

Code:

if (this.isFilter(ArticleLogic.FILTER_LOCK_READ))
{
   articleCriteria.setLockMode(LockMode.PESSIMISTIC_WRITE);
}

Regards,

MK

Hjackson5 · **Joined:** Fri Dec 09, 2011 12:35 am **Posts:** 2

It is obvious that I really want to be part of your site. I really love how you make people to have an interest in your site which helps me a lot. Thank you so much for this.

winewespeak · **Joined:** Sat Dec 17, 2011 6:23 am **Posts:** 1

Thanks for providing me the answer of the question I was just looking for.
----------------------------------------------------------------------------------------------
Kosher Wine