Db insertion row if not exist spring boot

Question

I have a two instances of one spring boot microservice. If two requests are sent at the same time, and the second request can update the row that was created by the first request. How i can prevent this? For example the table contains this columns :id,format,username,groupName and if a row exists (3,"test","test","test") and if we try to insert another row with same groupName and format,the insertion should fail.

Thx.

Regards, Petar

Gurkan İlleez · Accepted Answer · 2021-06-11 07:01:09Z

1

You can use optimistic lock and avoid overriding of row.

public class A {

   @Id
   private String id;

   @Version
   private Long version;

}

@Version annotation will cover optimistic lock for you. For More detail : https://www.baeldung.com/jpa-optimistic-locking

answered Jun 11, 2021 at 7:01

Gurkan İlleez

1,5831 gold badge10 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Db insertion row if not exist spring boot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related