where clause and left join

tads · **Posted:** Mon Feb 13, 2006 1:07 pm

Hi all,

I´m using Oracle 9 and Hibernate 2.1.4.

I have the following query in Oracle:

Code:

1   select count(*) from
2   viagem v, cartao c
3   where c.pan = v.pan(+)
4   and c.id_cartao_tipo = 2
5   and v.id_viagem_status(+) = 5 // I need this in HQL

this query returns 20 rows.

How can I do the where clause like the line 5 above
using Hibernate?

in HQL:

Code:

select count(c.pan)
from card
left join c.trips t
where c.cardType.idCardType = 2
and and t.tripStatus.idTripStatus = 5

this HQL returns 0 rows.

thanks