File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Unique constraint error with jpa Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Unique constraint error with jpa" Watch "Unique constraint error with jpa" New topic

Unique constraint error with jpa

Maria Michael

Joined: Sep 07, 2011
Posts: 18

I am currently stuck with this problem and I hope someone can assist.

My db is in SQL Server. I have certain uniqueness constraints on my tables.
When the entity manager persists it returns correctly the exception

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: Violation of UNIQUE KEY constraint 'UN_PERSONTBL_PASSP'. Cannot insert duplicate key in object 'dbo.PERSONTBL'.

Now I need a user friendly error message but I ca;t find a way to automate this other than doing string manipulation.


I agree. Here's the link:
subject: Unique constraint error with jpa
It's not a secret anymore!