How to show friendly message when getting unique constraint exception

[daphna deutsch]

I'm using JPA with hibernate and oracle DB.

I add unique annotation to my entity:

@Column(name="NAME", unique=true, nullable = false)
@NotNull(message="Field is required.")
private String name;

As i understand, this validation will not occure at runtime.
i do have contraint in the DB.

so when trying to save an object, i'm getting the exception

Caused by: java.sql.SQLIntegrityConstraintViolationException: 
ORA-00001: unique constraint (TEST.CU_X_OFFICE_01) violated

How can i show a "friendly" message to the user instead of the message from the exception?
(like in the case of not-null, where i define the message on the entity).

[lavnish lalchandani]

did you try adding

<error-page> <error-code>500</error-code> <location>/Error.jsp</location> </error-page>

to web.xml

In the JSP you can have If then else ...

String errMsg = getErrorMessage()
if(errMsg.contains("ORA-00001"))
{
 //  then display required user friendly msg
}
else if (errMsg.contains("ORA-00002"))
{
 //  then display required user friendly msg
}
else
{
 //  then display default user friendly msg
}

[daphna deutsch]

I might have more then one unique constraint in the same entity, and i want to show the user a specifc message about the problematic field.

[lavnish lalchandani]

Try iterating over the exception class
http://docs.oracle.com/javase/6/docs/api/java/sql/SQLException.html#iterator%28%29

The doc says

Returns an iterator over the chained SQLExceptions. The iterator will be used to iterate over each SQLException and its underlying cause (if any).