[jboss-user] [JBoss Seam] - EntityHome + nested persist = FK constraint violation

Hi, I have an Entity USER that can be in many GROUPs. This relationship is held in the USERGROUP entity. I have a page where a new User can be created and their groups selected. When I go to persist these using the following code I get a Foreign Key Constraint Violation from mySQL as the USER doesn't yet exist in the database. | public String add() { | | //Persist the user | String status = userHome.persist(); | log.info("Persisted User"); | | userHome.getEntityManager().flush(); | log.info("Flushed User"); | | //Process the groups | Iterator groupIter = groups.iterator(); | while(groupIter.hasNext()) { | Groups group = (Groups)groupIter.next(); | | //Use the EntityHome object to persist | userGroupListHome.create(); | userGroupListHome.getInstance().setUser(userHome.getInstance()); | userGroupListHome.getInstance().setGroups(group); | | userGroupListHome.persist(); | } | } | My understanding was that the flush() would actually force the transient object to be saved to the database. If I look in the DB it isn't there. Would appreciate any advice as this has driven me nuts once before. Thanks, Damian. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4044727#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...