"scotttam" wrote : I recently upgraded to RC9 and some of my queries that contain LEFT JOIN FETCHES to lazy load relationships are now failing. For example, the following query: | | | | SELECT c FROM Campaign c " | | "LEFT JOIN FETCH c.states " | | "LEFT JOIN FETCH c.dmas " | | "LEFT JOIN FETCH c.ads " | | "LEFT JOIN FETCH c.dayParts " | | "LEFT JOIN FETCH c.adSlots " | | "WHERE c.id = :id | | | | is now throwing the following exception: | | | | javax.persistence.NonUniqueResultException: result returns 4 elements | | | | If I grab the raw SQL, it definitely is coming back with 4 result where previously in RC8 there was only 1 result. | | Is this expected behavior or a bug? | | Thanks, | | Scott |
I'm using Release ID: JBoss [Zion] 4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000) with Java version: 1.5.0_08,Sun Microsystems Inc. i'm having a similar problem with RC9 so i switched back to RC8: in my query i have 2 parameters WITH DIFFERENT NAMES BUT if the VALUE is the same i get NonUniqueResultException while ON THE DB i have a single record identified by these parameters i'm quite confident this is a serious bug!!!! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3974162#3974162 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3974162 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
