Hi,

I'm trying to map 2 tables and an association table:

OCORRENCIA
----------------
A
B

CESTA
---------------
1
2

OCORRENCIA_CESTA
-------------------------
A 1
A 2
B 1

class Ocorrencia {
String name;
List<Cesta> cestas;
}

class Cesta {
int codigo;
List<Ocorrencia> ocorrencias;
}

Using "from Ocorrencia as o left join fetch o.cestas" Hibernate returns:

A [1,2]
A [1,2]
B [1]

Why A [1,2] apper 2 times?

Thanks,

Andre

I have the same pb, do you have find the solution????

This has been answered many times in this forum.

http://forum.hibernate.org/viewtopic.ph ... esults+set

Anthony's(one of the Hibernate guys) posted this answer to the above topic.

join has the same meaning as SQL join, so just use
Set results = new HashSet(query.list()) if you don't want duplicate results.



If you need to order the results, use a TreeSet instead of hashset.