Spring Data JPA and Hibernate:Exception handling for Database Constraints

Question

Currently I handle javax.persistence.PersistenceException by checking the StackTrace for the occurrence of a constraint name defined in a annotation.

Is there any more elegant way to solve the problem?

Spring Validation makes it quite easy as the ConstraintViolationExceptiongives me the Property Name and the Message defined in the constraint.

No. Because what message you get on a constraint violation is database product dependent. What database are you using? — Simon Martinelli
– Simon Martinelli, Commented Dec 30, 2017 at 17:01
I'm currently using H2 for testing. Later MySQL or Postgres. But I want to keep it independent from the database implementation. I guess most databases will at least return the name of the violated constraint. — dev
– dev, Commented Dec 31, 2017 at 10:41
Yes usually if they have meaningful names. But at the end the implementation is custom anyway — Simon Martinelli
– Simon Martinelli, Commented Jan 2, 2018 at 9:55

kafkas · Accepted Answer · 2017-12-30 20:51:31Z

1

You can use Controller Based Exception Handling. https://spring.io/blog/2013/11/01/exception-handling-in-spring-mvc#controller-based-exception-handling

 @ResponseStatus(value=HttpStatus.CONFLICT,
                  reason="Data integrity violation")  // 409
  @ExceptionHandler(DataIntegrityViolationException.class)
  public void conflict() {
    // Nothing to do
  }

answered Dec 30, 2017 at 20:51

kafkas

5231 gold badge4 silver badges11 bronze badges

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

1 Comment

dev Over a year ago

I'm actually using Controller Based Excption Handling returning a custom object containing detailed information about the violation (which field, etc). The point of my question is how to best map the database error message to a user-friendly error message.

Collectives™ on Stack Overflow

Spring Data JPA and Hibernate:Exception handling for Database Constraints

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related