Pessimistic locking with r2dbc

[vu3mmg]

Hi,

Could you please help me to get an example for Pessimistic locking with r2dbc .
Or could we use plain SQL statements such as

begin;
select * from foo where quatloos = 100 for update;
update foo set feens = feens + 1 where quatloos = 100;
commit;

This is to take care a scenario to update account balance for a transaction system .

regards
mahesh

[mp911de]

R2DBC is just the technical interfacing towards Java. Beyond that, this driver is able to send SQL through the Postgres wire protocol so it runs the SQL you provide to it.

[vu3mmg]

Thank you . So we can use all types of native locks provided by postgress .

[mp911de]

Yes, exactly.

[AmadeAli1]

Como usar bloqueio em postgres??