Convert sql query to Hql query

Question

please can someone help convert this sql query to an Hql query. Or can the query run as Hql?

select p.passport_data, b.unique_number, d.da38 as category
from passport p, dynamic_data d, basic_data b
where b.id = d.basic_data_fk
and p.basic_data_fk = b.id and d.da38 = 'SUBEB'

they entity classes are: Passport, BasicData, DynamicData

Passport entity class has fields/variables- passportData, basicData
BasicData entity class has fields/variables- id, uniqueNumber
DynamicData entity class has fields/variables- da38

You have to show us, how tables passport, dynamic_data and basic_data are mapped to hibernate entities. — mateuszlo
– mateuszlo, Commented Sep 21, 2016 at 17:17

Joe Taras · Accepted Answer · 2016-09-22 08:15:32Z

1

Try this:

select p.passport_data, b.unique_number, d.da38 as category
from Passport p, DynamicData d, BasicData b
where b.id = d.basicData
and p.basicData = b.id and d.da38 = 'SUBEB'

I suppose in your DynamicData exists a field named basicData (as in Passport class)

answered Sep 22, 2016 at 8:15

Joe Taras

15.4k7 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert sql query to Hql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related