select distinct elements(...)

run4fun · **Joined:** Sat May 29, 2004 2:16 pm **Posts:** 81

I'm using hibernate 2.1 with MySql 4.0.12 nt
I have this query:

Quote:

"select distinct elements(rel.turma.detalhe) from Relatorio rel";

but it lists repeated elements; on other words, the distinct clause has no effect at all.
Can someone explain me, please, how can i rewrite the query so that it only returns distinct elements?
thanks i advance

anthony · **Posted:** Wed Jun 09, 2004 5:54 pm

"select elements(rel.turma.detalhe) from Relatorio rel";

then create a new hashset with the results

run4fun · **Joined:** Sat May 29, 2004 2:16 pm **Posts:** 81

In first place thanks for your answer

anthony wrote:

"select elements(rel.turma.detalhe) from Relatorio rel";

then create a new hashset with the results

I'm sorry but i dont quite understand what i'm suposed to do after i make

Code:

Set novo = new HashSet();

after this what do i do? How can i have the distinct applied?
Can you pls help me further with any hint or idea?

anthony · **Posted:** Thu Jun 10, 2004 2:51 am

Set novo = new HashSet(session.find(yourQuery);

run4fun · **Joined:** Sat May 29, 2004 2:16 pm **Posts:** 81

Thanks for your help
i made:
Set novo = new HashSet(sess.find(query));
System.out.println("hashSet " + novo);
but keep getting repeated children.

My case is like this:
Parent A
Parent B
A's children:
a
b
c
B's children:
d
e
a
b

What i