对于Hibernate 3.3.2.ga中可用的悲观LockModes,我有两个问题:
- Thread 1, tries to obtain a lock and locks a set of rows
- Thread 2, tries to obtain the lock on the same set of rows (as were locked by Thread 1) at this time thread 2 gets a exception saying that Rows are locked哪一个是最好的悲观LockMode?
发布于 2015-05-25 12:57:07
select ... for update,因此锁用于当前事务的整个持续时间。。释放锁的唯一方法是提交或回滚事务。select ... for update锁将导致第二个事务等待第一个事务释放锁。如果您希望快速失败,则需要使用:诺瓦特,它将使用select ... for update no wait查询,如果无法获取锁,则会引发异常( Oracle和PostgreSQL支持此操作)。LockOptions,如下所示:
entityManager .unwrap(Session.class) .buildLockRequest(新LockOptions(LockMode.PESSIMISTIC_WRITE) .setTimeOut(LockOptions.NO_WAIT)) .lock(实体);要了解更多细节,请查看我来自苏黎世Voxxed的事务和并发控制演示文稿。
https://stackoverflow.com/questions/30425981
复制相似问题