Get the SQL Exception message from DataIntegrityViolationException

Question

Working on an api call which alters some data in DB.I am trying to provide a meaningful message from api in case there is an exception in JPA Layer. On any sql query run failure I get DataIntegrityViolationException from JPA which does not contain the exact reason of failure. Hence I am extracting the SQLException from it and then responding with the error message.

private String getSQLExceptionMessage(DataIntegrityViolationException e) {
    Throwable nextException = e.getCause();
    while (!nextException.getClass().equals(SQLException.class) && nextException.getCause() != null
            && !nextException.getClass().equals(nextException.getCause().getClass())) {
        nextException = nextException.getCause();
    }
    return nextException.getMessage();
}

Is there any better way to do this?

How do you plan to handle failure in your API? Throw the original exceptions, wrap them in your own exception type, ... ? — Ralf Kleberhoff
– Ralf Kleberhoff, Commented May 3, 2018 at 17:55
I have a list of error field in response, I was thinking to respond with 500 status code and fill in the error field with the list of messages. — Saurabh Kumar
– Saurabh Kumar, Commented May 4, 2018 at 3:27

Cepr0 · Accepted Answer · 2018-05-04 09:05:39Z

3

There is an utility class NestedExceptionUtils in Spring, which getMostSpecificCause method you can use to get the 'root' cause of any exception.

Regarding the error handling - you can implement a custom exception handler for DataIntegrityViolationException, extract the constraint name from the root cause, analyze it and create a corresponding message for the user.

Some error handling examples: 1, 2.

edited May 4, 2018 at 9:05

answered May 3, 2018 at 20:03

Cepr0

31.1k9 gold badges82 silver badges105 bronze badges

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

1 Comment

Saurabh Kumar Over a year ago

The problem with using NestedExceptionUtils.getMostSpecificCause is that it is giving the me the last SQLException in the getCause() chain which does not have the proper error message. However the first SQLException in the getCause() chain has the correct root cause message.

Dharman · Accepted Answer · 2021-06-03 10:55:39Z

1

Yeah you can use NestedExceptionUtils in Spring to get root course for any exception. Sample code below

 try {
          //your code
    
      } catch (DataIntegrityViolationException e){
          throw new DataIntegrityViolationException(NestedExceptionUtils.getMostSpecificCause(e).getMessage());
      }

edited Jun 3, 2021 at 10:55

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jun 3, 2021 at 10:50

KR93

1,35813 silver badges10 bronze badges

Collectives™ on Stack Overflow

Get the SQL Exception message from DataIntegrityViolationException

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related