• Post Reply Bookmark Topic Watch Topic
  • New Topic

Query Problem in Entity Bean.  RSS feed

 
Mahesh Malviya
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!