Hello. I've found out that using PESSIMISTIC_READ on an entity with postgres uses 'for update' lock, which is actually exclusive.
I understand JPA specification says that it's permissible to do that, but I really need a shared lock for what I'm trying to achieve. Is it possible to control somehow? I've had to resolve to using native queries, and I'd like to avoid this as much as possible... Thank you! Pawel. -- With best of best regards Pawel S. Veselov