[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2869) Atomic remove + add of unique properties to a persistent set fails

Atomic remove + add of unique properties to a persistent set fails ------------------------------------------------------------------ Key: HHH-2869 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2869 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.5 Environment: Hibernate 3.2.5 (2007.07.31); Oracle 9 Reporter: Pietu Pohjalainen Assignee: Diego Pires Plentz Priority: Minor Attachments: hibernate-unique-showcase.zip Trying to remove and add equal objects to a persistent set with unique property on, fails. E.g. we have a set 'set' with one object, "X" contained in it. A sequence of set.clear(); set.add("X"); session.update(set); produces a unique constraint exception from the underlying database, because the update first tries to add the newly added objects, and only after that it tries to remove those. E.g. Oracle produces the following exception: "Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (SHOWCASE.SYS_C0036053) violated" A workaround is would be to run the session.update(set); session.flush(); after clearing the set - but I would argue that interleaving the persistence-code with regular object handling code does not exactly fulfill the promise of 'transparent persistency'. Please see the attached showcase.zip, which sets up a database. There's a 'container', which contains a set of 'values', where values should be unique across all sets in the system. When trying to remove and add the same value to a set, the program throws an exception. The showcase driver script is located in class hibernate.Showcase. The object model classes are located in test.Container and test.Value.