I have some code that is doing a bulkUpdate and the SQL statement is a "delete from..."

Then I get this stack trace indicating a data integrity constraint violation. Any ideas? I am not inserting anything and there is no insert statement in the code in any of the methods I have written (that are listed in the stack trace below).



---
ERROR [Worker # 0] JDBCExceptionReporter.java:78| Duplicate entry '302-2000-1' for key 1
ERROR [Worker # 0] AbstractFlushingEventListener.java:301| Could not synchronize database state with session
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.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1136)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at org.springframework.orm.hibernate3.HibernateTemplate$38.doInHibernate(HibernateTemplate.java:1068)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.bulkUpdate(HibernateTemplate.java:1059)
at com.mycompany.base.dao.hibernate.PtDaoBaseImpl.deleteBy(PtDaoBaseImpl.java:750)

I see similar issues, while deleting the entries which are mapped to collections or hashmaps etc..

In case your need is to delete orphan ones due to data updates, try using @org.hibernate.annotations.Cascade(
value = org.hibernate.annotations.CascadeType.DELETE_ORPHAN)

Regards,
Nagendra

I tried the annotation but still saw the error. I also disabled all constraints in my DB (MySQL) but still saw it.

I then recreated all the tables with no constraints (MySQL) and am still getting the error. The only constraints I have now are primary keys.

If there are any other ideas, please let me know.

---
To disable all constraints I issued a statement like this on each table
alter table collsn_archive disable keys;

I then started up tomcat which made it's own connection to MySQL.

I'm not sure what the solution is at this point or how to find it. I could find no article on how to show all constraints in my DB (MySQL).

thanks

You may not be explicitly inserting anything, but is there a chance that you are loading something in a transaction, updating that POJO, and then later, the transaction gets committed without explicitly calling update or save? If that is the case, this might be causing the problem.