I have a code which acquires a Pessimistic write lock for a given criteria present on the source code below.There are many workers requesting the Web API for obtaining the resource, and I am using pessimistic write to achieve concurrency. IT works fine with MYSQL , but in case of Oracle, it doesnot work. COuld you please guid me how can I achieve this in Oracle DB.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Too aggressive pessimistic write lock in PostgreSQL | 2 | 3971 | March 18, 2022 | |
| Hibernates Handling of Pesimisstic Locking | 3 | 37 | January 16, 2025 | |
| Why does Hibernate execute 2 SQL query when using a PESSIMISTIC_WRITE LockMode on a JPQL query? | 5 | 1800 | January 17, 2019 | |
| Hibernate L1 cache + pessimistic_write lock question | 1 | 457 | May 12, 2021 | |
| How to use pessimistic lock when lazy load entities by ManyToOne relationship | 1 | 575 | July 2, 2021 |