[jboss-user] [JBoss jBPM] - Re: job executor explained in a nutshell
do-not-reply at jboss.com
Thu Jun 19 19:31:22 EDT 2008
anonymous wrote :
| No updates will be ever lost with higher isolation levels. The database will ensure that no two transactions that update the same data item can proceed.
Yes, I agree. But the db will block the second update until transaction with first update commits. There is no need to use optimistic locking with repeatable read isolation level because optimistic locking does not work with repeatable read.
If I understand it well, we have optimistic locking to prevent conflicting updates. We do not want to send two conflicting updates to db because db (in my case Oracle) will block the second update. We want application could see that another committed tx changed our row (that we already read) and we want to rollback our tx immediately (without blocking).
If we set transaction to repeatable read isolation level, in my opinion optimistic locking does not work, because during whole transaction we always read same version of our row. The application can not see that another commited tx updated some row. (bacause we have repeatable read).
I think that optimistic locking needs non-repeatable read to work but jbpm docs says opposite.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4159410#4159410
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4159410
More information about the jboss-user