Hi. I have a problem. I have two tables and i want connected table1'id with id of table2'id.
After i want take the rows of the table2 where the state in the row ( with same id) is "active".

In the class of table1 :


In the class of table2 :


In the dao :


i try the debugging. In the criteria there is a ac.state=active but hibernate doesn't do that and it do a other filter ( i don't understand the filter)

Help!! what is the problem? thanks !!!!! :(

SELECT t2.table1_id, t2.id AS table2_id, t2.table3_id_1, t2.table3_id_2
, t31.value AS x
, t32.value AS y
FROM table2 t2
LEFT JOIN table3 t31 ON t31.id = t2.table3_id_1
LEFT JOIN table3 t32 ON t32.id = t2.table3_id_2;

There is no need to join in table1. table2 has all you need - assuming there is a foreign key constraint guaranteeing referential integrity (all t2.table1_id are actually present in table1). Else you may want to join to table1, thereby selecting only rows present in table1.

I use LEFT [OUTER] JOIN (and not [INNER] JOIN) to join to both instances of table3 for a similar reason: it is unclear whether referential integrity is guaranteed. If not, JOIN would drop rows from the result where no matching row is present in table3. I assume you would rather display such rows with a NULL value for any missing x or y.

And table3.id needs to be UNIQUE, or we might multiply rows with several matches from each LEFT JOIN.