Spring data duplicate key value

Question

I have a table in postgresql with unique constraint and after insert i can get the error duplicate key value violates unique constraint. How best way to skip this error (for example, ON CONFLICT DO NOTHING) using spring data?

this problem is not related to id, another field msut be unique. — kros365
– kros365, Commented Mar 3, 2020 at 18:59
What exactly do you want to achieve? Have the row inserted by undermining the constraint (impossible) or have java not throw an exception and continue with the method? — InsertKnowledge
– InsertKnowledge, Commented Mar 3, 2020 at 19:09
I can just check if there is such a value in the database and if there is not, then insert it, but can I do it in 1 request? — kros365
– kros365, Commented Mar 3, 2020 at 19:14

Vesa Karjalainen · Accepted Answer · 2020-03-03 20:14:25Z

1

If you want to forget the row in case of conflict, just use INSERT ... ON CONFLICT (field) DO NOTHING.

answered Mar 3, 2020 at 20:14

Vesa Karjalainen

1,1058 silver badges16 bronze badges

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

Comments

Peter Lustig · Accepted Answer · 2020-03-04 01:07:11Z

1

You can catch the DataIntegrityViolationException exception and handle it the way you want e.g.

try {
    repository.save(myEntity);
} catch(DataIntegrityViolationException e) {
    System.out.println("Entity already exists. Skipping ...");
}

answered Mar 4, 2020 at 1:07

Peter Lustig

1,7232 gold badges22 silver badges39 bronze badges

1 Comment

Manoj Over a year ago

If you use dataIntegrityViolationexception that would lead to suppressing other db exceptions as well and not just duplicatekey exception

Collectives™ on Stack Overflow

Spring data duplicate key value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related