ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Qian" <daqiqi...@aol.com>
Subject Abator and Table join
Date Mon, 20 Mar 2006 21:41:42 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
<font size="2"><font face="Arial,sans-serif">All,<br>
<br>
I'm using Abator generated code for iBATIS DAO.<br>
<br>
Since Abator generated query doesn't support table join. I put
following mapping in the Abator generated xml file<br>
&nbsp;<br>
&lt;select id="Coupon" resultMap="CouponForDisplay" &gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp; select<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prod.product_name,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b.brand_name,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C.coupon_id<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM coupon as C,&nbsp; product_type
as prod,&nbsp; brand as b<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; C.product_type_id=prod.product_type_id
and
C.brand_id=b.brand_id;<br>
&nbsp; /select&gt;<br>
<br>
I got following error.<br>
<br>
</font></font><font size="2" face="Arial,sans-serif"><font  face="Arial,sans-serif">NestedRuntimeException:
Could not find SQL statement to include with refid
'parkview_coupon.abatorgenerated_Example_Where_Clause'</font></font><br>
<font size="2"><font face="Arial,sans-serif"><br>
Anything I did wrong?<br>
<br>
Thanks,<br>
Tony<br>
</font></font>
</body>
</html>


Mime
View raw message