I changed the subject that LockTimeoutException should be thrown, not is thrown. If you specify no-wait here, the exception should be LockTimeoutException. Although, technically, we can also throw PessimisticLockException.

Those are all JPA exceptions. LockAcquisitionException is a Hibernate exception - obviously the spec would not require us to throw that