Spring data duplicate key value

user_11613063 0
Viewed 1622

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?

spring-data-jpa postgresql spring java
2 Answers

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 ...");
}
user_68140730

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

user_43156010
Related