I have the table from which I want to get unique values for some entities.
public class UniqueGenerator { @Id @Column(...) private String id; @Column(...) private Long currentValue; ... }
... gen = entityManager.find(UniqueGenerator.class, MY_GENERATOR_ID); entityManager.lock(gen, LockModeType.WRITE); entityManager.refresh(gen); Long currVal = gen.getCurrentValue(); ...
1. SELECT .. FROM UNIQUE_GENERATORS WHERE ... 2. SELECT GENERATOR_ID FROM UNIQUE_GENERATORS WHERE ...FOR UPDATE 3. SELECT .. FROM UNIQUE_GENERATORS WHERE ...
SELECT ... FROM UNIQUE_GENERATORS WHERE ... FOR UPDATE