How to perform left join in Hibernate Query Language?

Question

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).

Renovate and simplify the myquery.Pls tell any possible answer — karthik.A.M, Aug 31 '13 at 07:14
why are you joining with A.TABLEB, it should be only TABLEB. — Ankit Bansal, Aug 31 '13 at 08:32
I need join two seperate table and match one column,that's why joining these table — karthik.A.M, Aug 31 '13 at 09:08

Joe Taras · Answer 1 · 2019-03-06T07:53:19.363

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.

1 Answers1