[jboss-user] [EJB 3.0] - Re: RC9 - LEFT JOIN FETCH queries that worked with RC8 are n

[icecuber]

"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