Hello,
I think it's a hibernate bug.
My HQL request is:
Code:
select xxx from XXXBean xxx
where xxx.id in (
(select yyyid.paEtbIdDemandeurDF from YYYBean yyy where yyy.id.numeroDossierFormation = 'AA-0000000001')
, (select zzz.id.etablissementIdDispensateur from ZZZBean zzz where zzz.id.numeroDossierFormation = 'AA-0000000001')
)
The generated SQL request ignore the '
(select zzz ...)' part!
Code:
Select ... ... ... from tableXXX xxx0_
where xxx0_.id in (select yyy_.fkxxId from tableYYY yyy1_ where yyy_.g_critere='AA-0000000001')
The select zzz disappear!!!, I should have a query like :
Code:
Select ... ... ... from tableXXX xxx0_
where xxx0_.id in ((select yyy_.fkxxId from tableYYY yyy1_ where yyy_.g_critere='AA-0000000001'),(select zzz_.fkxxId from tableZZZ zzz1_ where zzz_.g_critere='AA-0000000001'))
Any solution before I write this Query in a simple SQL Query?
Login
FAQ
Search