ConstraintViolation - duplicate key on re-save.

dgovoni · **Joined:** Wed Mar 28, 2007 2:51 pm **Posts:** 16

Hi,
I have a many to many mapping between Reports and Events and I can save my Report objects fine, and the Events get saved and associated through "reports_events" table.

But if I do that once, then try to save an Event object that was related to a Report already, I cannot save the Event object by itself. It complains the key is already there. Of course it is, but I want to update it if it is, save it new if it isn't.

Any tips on this greatly appreciated. Thanks!!!

Darren

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Can you show the exception?

dgovoni · **Joined:** Wed Mar 28, 2007 2:51 pm **Posts:** 16

(util.JDBCExceptionReporter 77 ) SQL Error: 1062, SQLState: 23000
(util.JDBCExceptionReporter 78 ) Duplicate entry '1f885a0531debd2b:-1e2164ce:112489fab56:-7ffe' for key 1
(def.AbstractFlushingEventListener 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)
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

Thanks for any ideas. There is an association between a Report<->Event already, but I want to save the Event object independently, after saving it before already.

Does hibernate require I use update after an initial save or is it smart enough to know?

Darren

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Try saveOrUpdate()