Spring Exception Handling Problem

[nitin pai]

In my DAO, I try to catch a generic Spring exception i.e DataAccessException for all type of DB problems. Then I wrap the message from it into my custom business exception.

But still, when I try to add a record with an existing primary key the application throws a stack trace of org.hibernate.exception.ConstraintViolationException without proceeding into the catch block of DataAccessException.

I even tried catching the most generic form i.e Exception. Here too, the application fails and throws the same stack trace. How can I catch this exception without failing the application.

I am using hibernate 3 with spring 2. The code which I am referring to is:

   
public boolean createEmployee(Employee emp) throws BusinessException {
try{
template.save(emp);
return true;
}catch (DataAccessException dae) {
throw new BusinessException(dae.getMessage());
}
}
 

and the stack trace on this execution is:

   
 
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:645)
at com.abc.dao.AdminDaoSpringImpl.createEmployee(AdminDaoSpringImpl.java:23)
at com.abc.service.AdminServiceImpl.registerEmployee(AdminServiceImpl.java:26)
at com.abc.tests.AdminDaoTest.main(AdminDaoTest.java:23)
Caused by: java.sql.BatchUpdateException: Duplicate entry '278233' for key 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 11 more
Employee Inserted
 

[Mark Spritzler]

Do you have the PersistenceExceptionTranslationPostProcessordefined in your configuration. With JdbcTemplate it is there automatically, but with Hibernate you need to add it to your configuration

  
<bean
class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>