[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2932) No ConstraintName when using PostgreSQL (BatchUpdateException instead of PSQLException)

No ConstraintName when using PostgreSQL (BatchUpdateException instead of PSQLException) ---------------------------------------------------------------------------------------- Key: HHH-2932 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2932 Project: Hibernate3 Issue Type: Sub-task Affects Versions: 3.2.2 Environment: Postgres 8.2 Reporter: Florian Rock Assignee: Diego Pires Plentz Priority: Minor > When using dialect org.hibernate.dialect.PostgreSQLDialect and a ConstraintViolationException is thrown, getConstraintName() does not get the right constraint name. > It seems that there is something wrong with the ConstraintNameExtractor. I still run into this problem. lets take a look into the PostgresDialect: ------ BOF ------ private static ViolatedConstraintNameExtracter EXTRACTER = new TemplatedViolatedConstraintNameExtracter() { public String extractConstraintName(SQLException sqle) { try { int sqlState = Integer.valueOf( JDBCExceptionHelper.extractSqlState(sqle)).intValue(); switch (sqlState) { // CHECK VIOLATION case 23514: return extractUsingTemplate("violates check constraint \"","\"", sqle.getMessage()); // UNIQUE VIOLATION case 23505: return extractUsingTemplate("violates unique constraint \"","\"", sqle.getMessage()); // FOREIGN KEY VIOLATION case 23503: return extractUsingTemplate("violates foreign key constraint \"","\"", sqle.getMessage()); // NOT NULL VIOLATION case 23502: return extractUsingTemplate("null value in column \"","\" violates not-null constraint", sqle.getMessage()); // TODO: RESTRICT VIOLATION case 23001: return null; // ALL OTHER default: return null; } } catch (NumberFormatException nfe) { return null; } } }; ------ EOF ------ My problem ist that sqle is a BatchUpdateException and not the suspected PSQLExpection. BatchUpdateException message doesn't contain the constraintName! I sloved that by adding "SQLException psqle = sqle.getNextException();" and replace the "sqle.getMesage()" with "psqle.getMessage()"