Hi! I have to Entities, say house and person. The relation is many-to-many.
I made some associations so that every person has one or more houses- So far the preconditions. I deleted all associations and then tried to find all persons without houses (which should return all persons). For this i used a my-sql finder query SELECT p FROM person p where p.houses IS EMPTY. (JBoss >= 3.2.4) or SELECT p FROM person p , IN (p.houses) here p.houses IS EMPTY. (JBoss < 3.2.4) The finder method returns not a single person. It seems like the deletion of the association is not applied to the database immediatly or the finder-mthod did not recognize the change. Anyone elready encountered this problem? Greets, Matthias View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846272#3846272 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846272 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user