hi in this part of code :
... FleetUser fu = (FleetUser) QueryUtils.getNamedQuerySingleResult(em, "FleetUser.findFleetUserForFleet.indexed", fleet); em.remove(fu); em.flush(); // HAVE TO FLUSH HERE FleetUser newFu = new FleetUser(fleet, user); fleet.setIsManaged(true); em.persist(newFu); ... ... If i remove the em.flush() call, when ending the transaction, an insert is done before the delete and fails cause of an unique contraint on a FLEET_ID column (to simulate one-to-many relation with association table). Why is the delete delayed after the insert or not done at all ? Christophe. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926545#3926545 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926545 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user