Hi there,

I have a criteria where I'm querying to get 5 rows. Hibernate createCriteria is returning first object meeting my restrictions 5 times instead of 5 different objects.

Elaboration(if required):
createCriteria is used with a single restriction, equivalent to "select * from <table> where id='100'"
I know in the data base, there are 5 rows with the id 100,
For this criteria, Hibernate is returning the single object 5 times having information of first row. I have verified by printing the hash code for all the 5 items and its seen that they all are same.

Any ideas?

Hi, i go through a problem like yours, does that object has any association (like OneToMany ) ?

see this post Elementos Duplicados em Criterias do Hibernate

when hibernate fetch the associations , it ends up with a table with associations and for each element in the association it ends up with the same root entity

that post suggest to use a Set implementation to discard duplicities or force hibernate to do a DISTINCT select in the entity (best approach)

i think it may help

Thanks for the response felipebn,

In my case I have many to many association with other table, but here my problem is not about the distinct root entiry. I have tried setting the distinct key, the query returned just one object, instead of 5 different objects.

What I mean is, If its the problem of Distinct Root entity, considering my above example, I should have got all the 5 rows duplicated to number of times the associated table entry, Say if the same restriction key entries are twice in the associated table, I should have got totally 10 rows as a result of query, i.e 5 different objects duplicated twice each.
But here, I'm getting just 5 rows, all are duplicates of first row.

Suggestions?

Ok, i understand it now... uhmm..

can you post a sample to illustrate your object and your criteria ?