-
1. Re: query.getResultList(); <= contains the same instance X t
monkeyden Nov 9, 2006 6:07 PM (in response to fbadt)When I had that problem it was an incorrectly defined primary key. The key(s) I specified didn't represent exactly one row. I also saw that all of the non-primary key fields had the same value, but the primary key field itself was null.
-
2. Re: query.getResultList(); <= contains the same instance X t
fbadt Nov 9, 2006 6:46 PM (in response to fbadt)In this case, there can, and often will, be more than one row that should be returned by getResultList (thus the use of this method not getSingleResult)
The lookup is not done by PK. It is done in a where clause like the below. There should be 10 rows / elements in the result; and there are 10. The problem is that all 10 are the same reference instead of 10 references corresponding to 10 rows returned:select v from TABLE1 v where v.SOMEGETTER = ?1
-
3. Re: query.getResultList(); <= contains the same instance X t
jblackmore Nov 15, 2006 5:30 PM (in response to fbadt)Do you have any collections on that entity? Are you using EJBQL with joins? I think I stumbled over a related scenario, except I'm calling 'getSingleResult' and getting an exception that there are 6 or 8 or 124 elements. No code or queries or even data changed since 4.0.4 in my case, and this just started happening after moving to 4.0.5.
I think the problem is that there may be only one instance of TABLE1 but 10 of some mapped OneToMany collection of your entity. I used a SortedSet instead of the default List (generated by Hibernate tools) to eliminate dups in 4.0.4, but that approach doesn't seem to do the trick any more. The other thing you can do is wrap the result list with a LinkedHashSet, to eliminate dups and preserve the order. It occurs to me that this is all part of the "paradigm mismatch", but I feel like I shouldn't have to do that, Hibernate should. But it works.
Please see this post for my "fix" that got me from 4.0.2 to 4.0.4, but now I have to go back into every EJBQL query invoked throughout the system and wrap it with a LinkedHashSet. Sigh, job security. :-)
/index.html?module=bb&op=viewtopic&t=82946&start=10
Anyone know a better solution? -
4. Re: query.getResultList(); <= contains the same instance X t
fbadt Nov 15, 2006 5:47 PM (in response to fbadt)Turns out what was thought to be the PK column was not. A PK on a sequence table was created and the former "pk" was used to group results on a common value.