"SELECT ... FOR UPDATE" not working for Hibernate and MySQL
- by Andres Rodriguez
Hi,
We have a system in which we must use pessimistic locking in one entity. We are using hibernate, so we use LockMode.UPGRADE. However, it does not lock.
The tables are InnoDB
We have checked that locking works correctly in the database (5.0.32), so this bug http://bugs.mysql.com/bug.php?id=18184 seems to be no problem.
We have checked that…