Skip to content

SELECT FOR UPDATE - Do we have support for this? #643

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
sougat818-streamotion opened this issue Sep 7, 2021 · 1 comment
Closed

SELECT FOR UPDATE - Do we have support for this? #643

sougat818-streamotion opened this issue Sep 7, 2021 · 1 comment
Labels
status: duplicate A duplicate of another issue

Comments

@sougat818-streamotion
Copy link

Hi everyone,

Been using this for a couple of months and been great. We have a requirement to run queries like SELECT FOR UPDATE . I can't find any way to do this via the r2dbc library. Can someone please confirm this or point me in the right direction. 🙏🏽

Appreciate any help! Thanks

@mp911de
Copy link
Member

mp911de commented Sep 7, 2021

You can provide your own SQL if you need to run queries that aren't supported yet by our SQL builder. Note that there's also spring-projects/spring-data-relational#1041 that duplicates this one.

@mp911de mp911de closed this as completed Sep 7, 2021
@mp911de mp911de added the status: duplicate A duplicate of another issue label Sep 7, 2021
DiegoKrupitza added a commit to DiegoKrupitza/spring-data-r2dbc that referenced this issue Feb 15, 2022
Methods which use the derive query functionality now can be annotated with `@Lock` to used a given `LockMode`. Right now there are two different modes `PESSIMISTIC_READ` and `PESSIMISTIC_WRITE`. Based on the dialect the right select is generated. For example for H2 `Select ... FOR UPDATE`.

Closes spring-projects/spring-data-relational#1041
Related tickets spring-projects#643
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: duplicate A duplicate of another issue
Projects
None yet
Development

No branches or pull requests

2 participants