Saving object employee with Sorted set as specified below

public class Employee {

/**
* @hibernate.set table="employee_machines" cascade="none" inverse="false" sort="com.mrt.vend.desktop.model.AssignedMachine"
* @hibernate.collection-key column="emd_emp_id"
* @hibernate.collection-composite-element class="com.mrt.vend.desktop.model.AssignedMachine"
*/

....
}

using code

session.saveOrUpdate(employee);

Hibernate tries to insert the existing row and falls over on database constraint key violation.
It should delete the row first then insert new one.

I tried
employee.setAssignedMachineList(null);
session.update(employee); employee.setAssignedMachineList(new list);
session.saveOrUpdate(dbData);

It does delete row and does not insert new one. Does anybody know how to make it working ?

Regards

Jerzy

Employee e = session.load(Employee.class, "1");
employee.setAssignedMachineList(new list);
session.close()

It does not work correctly , it tries to insert existing rows. Ordinary set first does row delete then insert, here we have insert only without a delete.
Reseting list does not help. It know it is possible to do it in 2 transactions, first set the list to null , commit, set new list , commit again, I do not see other way.

I noticed a similar problem. I have to set to null or empty set, commit, then set with new values. I'm experimenting with different equals() and hashCode() implementations to see if that helps.

-S

I noticed that it only seems to happen with composite element mappings. Also may have found a bug. If I call session.flush() within a transaction I get duplicate values on the composite.

-S