Problem with left outer join

reolca · **Joined:** Tue Oct 11, 2005 10:57 am **Posts:** 13

Why this hql do not execute the outer join? The result it's like just a inner join (Hibernate ignores the outer join)!

Code:

from Programa as prg
      left outer join fetch prg.credenciamentos as cre 
      inner join fetch cre.professorCredenciado as prc
      inner join fetch prc.pessoa as pes
where cre.status = 'P'
order by prg.nome asc, pes.nome asc;

I alredy tried to in this form:

Code:

from Programa as prg
      left outer join fetch prg.credenciamentos as cre 
order by prg.nome asc;

But still don't work!

I'm using Hibernate 3.0.5 and Postgre 8.1.

Thanks in advance.

reolca · **Joined:** Tue Oct 11, 2005 10:57 am **Posts:** 13

No one?

igor.inas · **Joined:** Mon Nov 27, 2006 6:16 am **Posts:** 5

If you look at the generated SQL, you will see, that all JOINs are applied in a flat manner, from left to right. That means, that any inner join affects the result. You would need to add parentheses to create a composite "sub-join". I can't explain it more accurately now.

Please post the generated SQL and I will reply with a modified SQL. What I am afraid is, that you can't really control the composition of join in HQL. I have a similar problem at the moment ...

ohanny · **Posted:** Thu Sep 25, 2008 3:46 am

I think that the following hql may solve your problem :

from Programa as prg left join prg.credenciamentos as cre where cre.professorCredenciado is not null or prg.credenciamentos is empty