How to construct an Hibernate HQL query containing a left join with a subquery in JBoss EAP 5?

Solution Verified - Updated -

Issue

  • How to translate the following sql query into hql?
SELECT customer.id , utility.data
FROM designation customer
LEFT JOIN
  (select tel.role_id, tel.data
   from role_DES des
   inner join RoleDES_use use on des.id=use.designation_id
   inner join code_value cv on use.use_cd=cv.id
   where cv.code='MC') utility
on (customer.id=utility.role_id )

Environment

  • JBoss Enterprise Application Platform (EAP) 4.3, 5.x
  • Hibernate 3.2.4 (Included in EAP 4)
  • Hibernate 3.3.2 (Included in EAP 5)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content