You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
currently to lock rows one can trigger a statement like the following
findTop5ByDepartmentEqualsForUpdate
however with concurrent threads wanting to run the same query, the second thread is blocked as it is trying to update potentially the same rows
to avoid this, one can use the SELECT FOR UPDATE SKIP LOCKED variant, which would allow the second thread to get a second set of non-locked rows; We need support in Micronaut Data thus for a query finder method like ...
findTop5ByDepartmentEqualsForUpdateSkipLocked
Similarly, we may want to quickly fail if rows are already locked, in which case we can use SELECT FOR UPDATE NOWAIT functionality.
findByNameEqualsForUpdateNoWait
The text was updated successfully, but these errors were encountered:
Feature description
currently to lock rows one can trigger a statement like the following
findTop5ByDepartmentEqualsForUpdate
however with concurrent threads wanting to run the same query, the second thread is blocked as it is trying to update potentially the same rows
to avoid this, one can use the SELECT FOR UPDATE SKIP LOCKED variant, which would allow the second thread to get a second set of non-locked rows; We need support in Micronaut Data thus for a query finder method like ...
findTop5ByDepartmentEqualsForUpdateSkipLocked
Similarly, we may want to quickly fail if rows are already locked, in which case we can use SELECT FOR UPDATE NOWAIT functionality.
findByNameEqualsForUpdateNoWait
The text was updated successfully, but these errors were encountered: