sql query to hql

*alexandre* · **Joined:** Tue Jun 06, 2006 3:37 am **Posts:** 29

Hello,

I'm trying to translate a sql query to hql query with join

here is my query :

SELECT element.* FROM element, used_table, used_field where used_table.name = 'product' and element.ref_table = used_table.id_table and used_field.data_type = 1 and element.ref_field = used_field.id_field

thx in advance !

paul.barry · **Posted:** Thu Aug 17, 2006 10:58 am

It depends on what your mapping looks like, but I think something like this should work:

Code:

from Element as e
    inner join e.table as t
    inner join e.field as f
where
    t.name = 'product' and
    f.data_type = 1

*alexandre* · **Joined:** Tue Jun 06, 2006 3:37 am **Posts:** 29

yes if found a similar version

createQuery("from ElementDb element join element.usedTable ut join element.usedField uf where ut.name = 'PRODUCT' and uf.dataType = 1")

marco-p · **Posted:** Thu Aug 17, 2006 11:09 am

Thinking in SQL doesn't help with Hibernate. You should use a object oriented approach.
Did you define the relation between your entities?
I can make a guess:

Code:

SELECT element FROM element join element.used_table ut join ut.used_field uf where ut.name = ? and uf.data_type = ?

defining the many-to-one relations between element and used_table and between used_table and used_field.

See chapter 5 and 14 for more info on how to do it.