HQL: left join unrelated tables - impossible???

nkarasev · **Joined:** Tue May 03, 2005 7:13 pm **Posts:** 4

Yes, I want to use left join on unrelated tables in HQL.
Is this possible at all?
(by "unrelated" I mean that the tables do not have association in mapping)

Great thanks!

pksiv · **Posted:** Thu Sep 01, 2005 2:37 pm

nkarasev wrote:

Yes, I want to use left join on unrelated tables in HQL.
Is this possible at all?
(by "unrelated" I mean that the tables do not have association in mapping)

Great thanks!

You can't specify the "join" in HQL since joins are done on associations but you should get the same results using a query like this.

Code:

select .... from ObjectA a, ObjectB b where a.someId = b.someId

etienne · **Posted:** Thu Sep 01, 2005 3:19 pm

Quote:

You can't specify the "join" in HQL since joins are done on associations but you should get the same results using a query like this.

The where clause as shown here act like an "Inner Join", nkarasev want to do a Left Outer Join.

I dont see how Hibernate can do an Left Join... Is that possible? It is still a trivial query. I have exacly the same issue with Hibernate. Must we map all possible join between Pojo to be able to use te left join?

Etienne.

nkarasev · **Joined:** Tue May 03, 2005 7:13 pm **Posts:** 4

Thanks to all who answered!

I really needed LEFT join, so I take it as I need to resort to other
means of getting my task solved.

Cheers.

etienne · **Posted:** Fri Sep 02, 2005 9:24 am

Hi,

I just got this reply confirming that outer join is not possible between unrelated table.

http://forum.hibernate.org/viewtopic.php?p=2259206#2259206

it is quite suprizing for a persistence layer (as good) as Hibernate.

Etienne.