posted 19 years ago
Hi,
loan_id(java.lang.Long), seq(java.lang.Short) and period_ending_dt(java.util.Date) is the composite primary key in two tables, Quarterly and Populate.
I have two entity beans corrensponding to these two tables. one is Quarterly and other is Populate.
When I fires query in my Quarterly Entity bean as
select object(o) from Quarterly o where o.loan_id not in(select x.loan_id from Populate x) .. It works fine.
But....
When I write..
select object(o) from Quarterly o where o.period_ending_dt not in(select x.period_ending_dt from Populate x) .. It does not work.
Error displayed is...
Error generating findAllUnPopulatedQuarters query for bean Quarterly (Abstract schema name=Quarterly) Error =query can not be pushed down. Query = 'select object(o) from Quarterly o where o.period_ending_dt not in( select x.period_ending_dt in Populate x)'
The only change I made is that I change the colum name form loan_id to period_ending_dt.
Any suggestions.
Thanks and Regards
Mahesh Malviya