pessimistic locking: Lock database entity grails

Question

I followed the grails documenation it says that to do pessimistic locking I can do like this:

def plan = Plan.findWhere(user:user, [lock: true])

so this locks the plan instance until save is finished on it.Now in my case I want to lock multiple plans at once,like this:

def plan = Plan.findAllWhere(user:user, [lock: true])

I am doing this in grails service which are transactional by default,but the above line is not working as expected.It doesn't lock all the rows and throws stale state exception if a concurrent transaction is performed.

How can I lock multiple rows when reading?

Please see a related question for more info : concurrent transaction in grails resulting in database stale state exception

moskiteau moskiteau · Accepted Answer · 2013-11-22T14:50:33

You can do something like this, which works for me:

Process.withNewTransaction {
    def process = Process.get(job.process.id)
    process.lock()
    process.sessionId = 0
    process.processId = 0
    process.save(flush:true)    
}

pessimistic locking: Lock database entity grails

1 Answers