CODEWITHSUNDEEP
javadatabasehqlaliases
Harshul Pandav
Harshul Pandav

Reputation: 1036

HQL Query with alias

I am trying to execute an hql query with aliases 

select **clbs.id as id**  
  from ClaimDO cl, ClaimBillSummaryDO clbs, HospitalDO h 
  where clbs.parentGuidObj.id=cl.id and h.id=cl.hospitalSeq and cl.id= '10721'

and I get the following error

org.hibernate.QueryException: , expected in SELECT

However the query runs without error if i remove the alias

select **clbs.id** 
  from ClaimDO cl, ClaimBillSummaryDO clbs, HospitalDO h
 where clbs.parentGuidObj.id=cl.id and h.id=cl.hospitalSeq and cl.id= '10721'

Upvotes: 1

Views: 7051

Answers (1)

carbontax
carbontax

Reputation: 2184

Why are you not using mappings to join your entities? You might as well use native queries to do this. HQL would look more like the following. I have omitted the HospitalDO join since it doesn't look meaningful.

    select clbs.id from ClaimDO cl join cl.parentGuidObj clbs where cl.id = :id

Upvotes: 1

Related Questions