Update and Return Updated column using returning keyword in same query in java jdbc code

Question

 update account set lastusedval=lastusedval+1 where isactive=1 returning 
 lastusedval;

How to execute above query in java? when i tried to execute in oracle its working but in java hibernate/jpa no way to store return value in update query.

By executing above query intention is to apply lock on db level when more than 1 request comes

Possible duplicate of Creating an UPDATE RETURNING query in Hibernate — Gord Thompson
– Gord Thompson, Commented Sep 16, 2018 at 12:47
Also possibly of interest: Execute native sql with hibernate — Gord Thompson
– Gord Thompson, Commented Sep 16, 2018 at 12:51

Mark Rotteveel · Accepted Answer · 2018-09-16 13:40:44Z

0

Using jdbc prepared statement with registeroutparameter might help you to resolve this issue.

Creating an UPDATE RETURNING query in Hibernate

edited Sep 16, 2018 at 13:40

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Sep 16, 2018 at 12:46

beattles

1

Sign up to request clarification or add additional context in comments.

1 Comment

Gord Thompson Over a year ago

Um, registerOutParameter (note spelling) is used with CallableStatement, not PreparedStatement. Good catch on the dup, though.

Collectives™ on Stack Overflow

Update and Return Updated column using returning keyword in same query in java jdbc code

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related