Howdy all,

I have been trying to do a select for update and have been somewhat un-succefull. Here is the psuedo code I have been trying.

1. load a object with LockMode.Read and/or LockMode.Update. session.lock(...) again with a LockMode. I update the object, update, and flush.

2. Specifiy a Lock mode on the beginTransaction() and use step1.

The result is that the lock is a table lock on the moment I flush.
:(

So, how does one lock a row on the moment of the read??? Did I miss something in the configuration??? Is there something I have to set in SQL server???


anyone.... Help please