Hibernate version: 3.0.5
I'll use two simple tables to show my situation.
Code:
Product Translation
--------------------- ----------------------
id, pk id, pk
productCode, not null language, not null
entityCode, not null
description, nullable
I need to produce an sql like the following one
Code:
select p.idProduct, t.description from product p left outer join translation t on p.productCode=t.entityCode and t.idLanguage=?
Can I do it with HQL or Criteria?
My problem is related to the conditional outer join.
Thanks for any help.
Login
FAQ
Search