I have 2 classes User and Event :


when i execute the following query



results are duplicated.
What 's wrong with it ?

Could you show what SQL it trnaslates into?

PS: I think you need something like "select distinct"

Here is the SQL SELECT
Be careful : evenement is event and internaute is user

Hibernate: select evenemen3_.identifiant as x0_0_ from internaute internau0_ lef
t outer join evenement evenemen1_ on internau0_.identifiant=evenemen1_.internaut
e_id, evenement evenemen2_, evenement evenemen3_ where internau0_.identifiant=ev
enemen2_.internaute_id and evenemen2_.identifiant=evenemen3_.identifiant and ((i
nternau0_.identifiant=? )and(evenemen1_.periode=? ))
Hibernate: select evenemen0_.identifiant as identifi1_0_, evenemen0_.type as typ
e0_, evenemen0_.periode as periode0_, evenemen0_.heure as heure0_, evenemen0_.ti
tre as titre0_, evenemen0_.description as descript6_0_, evenemen0_.remarque as r
emarque0_, evenemen0_.heureFin as heureFin0_, evenemen0_.observation as observat
9_0_, evenemen0_.lieu as lieu0_, evenemen0_.indication as indication0_ from even
ement evenemen0_ where evenemen0_.identifiant=?
Hibernate: select evenemen0_.identifiant as identifi1_0_, evenemen0_.type as typ
e0_, evenemen0_.periode as periode0_, evenemen0_.heure as heure0_, evenemen0_.ti
tre as titre0_, evenemen0_.description as descript6_0_, evenemen0_.remarque as r
emarque0_, evenemen0_.heureFin as heureFin0_, evenemen0_.observation as observat
9_0_, evenemen0_.lieu as lieu0_, evenemen0_.indication as indication0_ from even
ement evenemen0_ where evenemen0_.identifiant=?


and the result :
essai ,10:00
essai ,10:00
RDV M. DUPOND ,8:00
RDV M. DUPOND ,8:00

What are you trying to do?

It looks like you want to load ALL events of the specific user. Correct? In this case try to use "select distinct ...".

But your query looks very inefficient for this case.

If you need to load only events with specific period,



will do the job.

You are right. I want to load ALL events of the specific user that match a specific date

For example, all events of user flam70 for the day "2003-12-12".

You seem to say that it looks very inefficient. So is there a better way to do so.

OK. Your query works well. THANKS

Look, "all events of the specific user that match a specific date" and "ALL events of specific user" are a bit different things :)