Hello,
When executing a criteria i'm getting repeated object. The criteria is:

List results = session.createCriteria(MyClass.class)
.add(Expression.eq("attr1", attr1))
.add(Expression.eq("attr2", attr2))
.list();

And the hbm.xml file for MyClass is:

<hibernate-mapping package="pachage">
<class name="MyClass" table="TABLE" >
<id name="attr1" column="ATTR1"/>
<property name="attr2" column="ATTR2" />
</class>
</hibernate-mapping>

On the other hand, if i do the query like this :
String sql_query = "select mc.attr1, mc.attr2 from MyClass mc" +
"where attr1='" + attr1 +
"' and attr2='" + attr2 +"'" ;
List list = session.createQuery(sql_query).list();

Does anybody knows why ?
Thanks in advance

What about popping the results into a Set, rather than a List. A Set will not allow duplicates.

A sneaky solution, but it will work.

Can u explain this in detail

Is that your complete mapping or do you have some collection marked with an outer join? What's the sql that gets generated?

Cameron : i don't think it's gonna work. I want to retrieve all my records and the thing is that with criteria i'm having only the first record duplicated many times. But if i do it with the "createQuery" i'm getting all my records...
So i don't think that popping the results in a set will work...

VampBoy : yes that's the only mapping, it's just a simple query in one table.

The query produced by hibernate is the same in both cases.. so i imagine it's something wrong with my hibernate configuration...

Any way thank you both very much !