CODEWITHSUNDEEP
oracle-databasehibernatehql
karthik.A.M
karthik.A.M

Reputation: 135

How to perform left join in Hibernate Query Language?

This is my HQL query, but it isn't working and is throwing an error.

Hql query:

SELECT 
    *
FROM 
    TABLEA A 
LEFT JOIN 
    A.TABLEB B 
WHERE 
    A.COLUMNNAME = B.COLUMNAME

and it causes this error:

org.hibernate.QueryException:
This Query caught Exception. could not resolve property: of TABLEB:TABLEA.

How can I solve this problem? Actually I retrieved a value from more than one table. This query doesn't work with CreateQuery(strQuery).

Upvotes: 10

Views: 36870

Answers (1)

Joe Taras
Joe Taras

Reputation: 15379

In HQL you can use LEFT JOIN only with linked property in main entity:

Sample

EntityA has an object entityB of type EntityB so you can

SELECT A FROM EntityA A LEFT JOIN A.entityB B WHERE ...

IF EntityA haven't entityB property but is EntityB have a property entityA, you can't write this:

SELECT A FROM EntityA LEFT JOIN EntityB B WHERE B.entityA = A

because you have an error. This is an Hibernate issue not resolved yet.

Upvotes: 14

Related Questions