RE: Abator and Table join

Rashmi Dave Tue, 21 Mar 2006 01:30:24 -0800

Hi Tony,

Can you paste the code snippet which calls this query?

Thanks

~Rashmi

From: Tony Qian [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 3:12 AM
To: [email protected]
Subject: Abator and Table join

All,

I'm using Abator generated code for iBATIS DAO.

Since Abator generated query doesn't support table join. I put following mapping in the Abator generated xml file

<select id="Coupon" resultMap="CouponForDisplay" >
     select
        prod.product_name,
        b.brand_name,
        C.coupon_id
      FROM coupon as C, product_type as prod, brand as b
      WHERE C.product_type_id=prod.product_type_id and C.brand_id=b.brand_id;
/select>

I got following error.

NestedRuntimeException: Could not find SQL statement to include with refid 'parkview_coupon.abatorgenerated_Example_Where_Clause'

Anything I did wrong?

Thanks,
Tony

RE: Abator and Table join

Reply via email to