RIGHT OUTER JOIN problem

whizz_kid · **Joined:** Thu Feb 05, 2004 4:59 am **Posts:** 23

How to write HQL query, which joins two classes, which are not joined in .hbm.xml configuration files ?
I need a query, like this :
query_str = "SELECT t1.id, t2.name
FROM Table1 t1 RIGHT OUTER JOIN Table2 t2
ON t1.id = t2.id "
The above script throws exception :(
Any ideas ? Maybe to use JDBC - is the only choice in this situation ?

christian · **Posted:** Fri Apr 02, 2004 9:52 am

Theta style join in the where clause on a cartesian product:

from A a, B b where a.id = b.id;

whizz_kid · **Joined:** Thu Feb 05, 2004 4:59 am **Posts:** 23

christian wrote:

Theta style join in the where clause on a cartesian product:
from A a, B b where a.id = b.id;

But it won't be a RIGHT OUTER JOIN !

christian · **Posted:** Tue Apr 06, 2004 6:01 am

Thats correct. Map the classes or use native createSqlQuery() if you can't rewrite that query (should be trivial).

CatchSandeepVaid · **Joined:** Wed Aug 22, 2007 5:53 am **Posts:** 38

Does theta join supports outer joins in latest version of hibernate?

ppareit · **Joined:** Fri Nov 11, 2005 4:35 pm **Posts:** 23

Hi,

I switched from hibernate to OpenJPA for that reason.
OpenJPA is better for complex mappings.

Good luck,
Pieter