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

[Florian Rock (JIRA)]

 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
            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()"



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira