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 | 3811 | March 18, 2022 | |
| Why does Hibernate execute 2 SQL query when using a PESSIMISTIC_WRITE LockMode on a JPQL query? | 5 | 1775 | January 17, 2019 | |
| Hibernate L1 cache + pessimistic_write lock question | 1 | 438 | May 12, 2021 | |
| How to use pessimistic lock when lazy load entities by ManyToOne relationship | 1 | 554 | July 2, 2021 | |
| How to log entity locking | 3 | 883 | October 11, 2022 |