Hi All,

Is it possibe to implement the outer join with string literal ?
I have no permission to use session.createSqlQuery()

I will have to use HQL using session.createQuery().

I want to implement the following SQL in hibernate.

SQL ::
select <specified output>
from tableA a, tableB b
where
a.id = b.id (+)
a.name = b.name (+)
a.address (+) not in ('KOL', 'MUM')

Can any one please help me how can I implement the above SQL ?

Please give me a detailed step (changes in mapping file, pojo object etc) for the implementaion.

Thank you in advanced.

Thanks and regards --
Sumanta Bhattacharyya