Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Executing aggregate function in ibatis

 
Khushwinder Chahal
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to run the following query in the ibatis :
Code:



As you can see that it is returning price_list_id along with the customer numbers in each price list. I have a doubt in mapping this query's output to my resultmap class. My result map class is billing_invoice _line which is price_list_id and customer_id as bean properties.
So my mapping looks like:

Code:



I just want to know that the way i am mapping it is it right or not?
I am doubtful about the customer_id mapping as it is returning the count(*).
Is there any other way out of doing this?
Any help will be greatly appreciated.

Thanks and Regards,
Khushwinder
Edit/Delete Message
 
Khushwinder Chahal
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am getting the following exception in this:



not found in the sql map file.

If any body has any idea please help me out.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic