Specifically, in JDBCException convert(SQLException sqlException, String message, String sql), the code path to determine the constraint name will return null if the constraint name is kept in a wrapped exception.

Ex: If you get a
BatchUpdateException:
next: PSQLException ("ERROR: duplicate key value violates unique constraint my_table_id")

Then the code will not be able to determine that the constraint was "my_table_id".