0 Replies Latest reply on Nov 11, 2010 1:33 PM by pimek123

Handling JPA Exception (unique constraint violation)

pimek123 Nov 11, 2010 1:33 PM

Hello everyone!

I am developing an application based on FUSE ESB 4, which uses JPA 2.0 for the persistence layer, underlying provider is Hibernate. Database used is Oracle 10g.

My application is used to transfer huge amounts of measurements data (physics). I want to avoid situation in which someone inserts the same measurement data twice, thus I put an unique constraint on . This is database's job to prevent duplicated data being stored. It frees me from implementing data duplication avoidance mechanisms in my application, which is fine.

Simplified code for storing data looks as follows:

EntityManager em = entityManagerFactory.createEntityManager();

try {

em.getTransaction().begin();

int howMany = 0;

for (Data data: dataSet) {

data = ...

// ... Data preparation stuff goes here...

// ...

em.persist(data);

// after 20 times, flush

if (howMany++ % 20 == 0) {

// flush raises an exception

em.flush();

em.clear();

}

em.getTransaction().commit();

} catch (PersistenceException e) {

logger.debug("I handle unique constraint violation which is completely normal and fine: + e.getMessage()");

// Rollback the transaction and proceed as nothing happened

em.getTransaction().rollback();

} finally {

em.close();

}

Now as some data which has already been in the database comes and is tried to be inserted, an exception is raised, which I would like to handle with the code above.

Instead I get a bunch of exceptions in my log files looking as follows:

org.hibernate.exception.ConstraintViolationException: could not insert:

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)

at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)

at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)

at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:358)

at $Proxy161.flush(Unknown Source)

at MyApp.databaseBinding.DatabaseBindingImpl.saveGeneralMeasurement(DatabaseBindingImpl.java:234)

at MyApp.DatabaseBindingImpl.saveData(DatabaseBindingImpl.java:163)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)

at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)