How to retrieve SQL error code on postgres database via DataAccessException?

Question

I am trying to delete a record from database using spring data jpa on postgresql database and I need to capture the sql error code

try {
    userRepository.deleteUser(id);
} catch(org.springframework.dao.DataAccessException e) {
    // here
}

How do I get the sql error code in catch block? getCause or getMessage method is not retrieving sql error code

What about getRootCause()? That should return the original JDBC exception — user330315
– user330315, Commented Jul 30, 2019 at 7:23

MWiesner · Accepted Answer · 2019-07-30 09:31:42Z

4

In the official JavaDoc of the interface SQLExceptionTranslator we find this hint:

The returned DataAccessException is supposed to contain the original SQLException as root cause. However, client code may not generally rely on this due to DataAccessExceptions possibly being caused by other resource APIs as well. That said, a getRootCause() instanceof SQLException check (and subsequent cast) is considered reliable when expecting JDBC-based access to have happened.

So, with this information in mind, you can write code like this:

try {
    userRepository.deleteUser(id);

} catch(org.springframework.dao.DataAccessException e) {
    if( e.getRootCause() instanceof SQLException) {
        SQLException sqlEx = (SQLException) e.getRootCause();
        int sqlErrorCode = sqlEx.getErrorCode();
        // do further things from here on...
    }
}

Hope this helps.

edited Jul 30, 2019 at 9:31

answered Jul 30, 2019 at 9:23

MWiesner

9,07612 gold badges40 silver badges72 bronze badges

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

1 Comment

Praveen Rajan Over a year ago

Thanks a lot, it is working fine with the above code

Collectives™ on Stack Overflow

How to retrieve SQL error code on postgres database via DataAccessException?

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