How To: OUTER JOINS ?

[allforjava.allforjava.aol.in]

Dear Team,

I guess RESTRICTION in EntityQuery makes INNER JOIN.

1. So is there any way for OUTER LEFT/RIGHT JOIN using RESTRICTIONS?

2. Any way to add RESTRICTION between multiple JOINS?

e.g I need to convert SQL to EJBQL using EntityQuery, from:
"
from     issues right outer join issue_status
          on issues.status = issue_status.id
and               issues.created_by='loggedInUser'          
          left outer join issue_priority
          on issues.priority = issue_priority.id"

[allforjava.allforjava.aol.in]

The query is working with 'em.createNativeQuery()'. However I need to use EntityQuery to process my query using RESTRICTIONS.

Kindly assist.

[allforjava.allforjava.aol.in]

Prathamesh Gaddam wrote on Jul 07, 2009 16:23:


1. So is there any way for OUTER LEFT/RIGHT JOIN using RESTRICTIONS?

Solved! URL: http://docs.jboss.org/hibernate/stable/entitymanager/reference/en/html/queryhql.html

http://www.redhat.com/docs/manuals/jboss/jboss-eap-4.2/doc/hibernate/EntityManagerUserGuide/EJBQLTheObjectQueryLanguage-EJBQLexamples.html

However unable to find the details for the following. Please assist:

Prathamesh Gaddam wrote on Jul 07, 2009 16:23:


2. Any way to add RESTRICTION between multiple JOINS?