ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Qian" <daqiqi...@aol.com>
Subject RE: Abator and Table join
Date Tue, 21 Mar 2006 16:54:26 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
<font face="Arial,sans-serif"><font size="2">Rashmi,<br>
<br>
Thanks for response. I figured out the problem.&nbsp; All Abator generated
configuration files have name space. The problem was i set
useStatementNamespaces in sqlMap configuration file to 'false".&nbsp; Once I
set to true. Everything worked fine. The error message is not very
clear.<br>
<br>
thanks,<br>
Tony<br>
<br>
<span type="cite">Rashmi Dave wrote on 3/21/2006, 4:33 AM:</span>
</font></font>
<p><font face="Arial,sans-serif" size="2"></font></p>
<blockquote type="cite"  style="border-left: thin solid blue; padding-left: 10px; margin-left:
0pt;"><font  face="Arial,sans-serif" size="2"></font>
  <div class="Section1"><font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy">Hi
Tony,<o:p></o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy"><o:p>&nbsp;</o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy">Can
you paste the code snippet which calls
this query?<o:p></o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy"><o:p>&nbsp;</o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy">Thanks<o:p></o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy">~Rashmi<o:p></o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" color="navy" face="Arial"><font  face="Arial"><font
size="2"><font color="navy"><font color="navy"><o:p>&nbsp;</o:p></font></font></font></font></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <div><font face="Arial,sans-serif" size="2"></font>
  <div class="MsoNormal" align="center" style="text-align: center;"><font  size="3"
face="Times New Roman"><span style="font-size: 12pt;">
  <hr size="2" width="100%" align="center" tabindex="-1"></span></font></div>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font face="Arial,sans-serif" size="2"><b><font
 size="2" face="Tahoma"><font face="Tahoma"><font size="2">From:</font></font></font></b></font><font
 size="2" face="Tahoma"><font face="Tahoma"><font size="2"> Tony Qian
[<a class="moz-txt-link-freetext" href="mailto:daqiqian2@aol.com">mailto:daqiqian2@aol.com</a>]
<br>
  <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, March
21, 2006 3:12
AM<br>
  <b><span style="font-weight: bold;">To:</span></b> <st1:PersonName
 w:st="on"><a class="moz-txt-link-abbreviated" href="mailto:user-java@ibatis.apache.org">user-java@ibatis.apache.org</a></st1:PersonName><br>
  <b><span style="font-weight: bold;">Subject:</span></b> Abator and
Table join</font></font></font><font face="Arial,sans-serif" size="2"><o:p></o:p></font></p>
  <font face="Arial,sans-serif" size="2"></font></div>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="3" face="Times New Roman"><span  style="font-size:
12pt;"><o:p>&nbsp;</o:p></span></font></p>
  <font face="Arial,sans-serif" size="2"></font>
  <p class="MsoNormal"><font size="2" face="Arial"><font face="Arial"><font
 size="2">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>
NestedRuntimeException: Could not find SQL statement to include with
refid
'parkview_coupon.abatorgenerated_Example_Where_Clause'</font></font></font><font
 face="Arial,sans-serif" size="2"><br>
  </font><font size="2" face="Arial"><font face="Arial"><font size="2"><br>
Anything I did wrong?<br>
  <br>
Thanks,<br>
Tony</font></font></font><font face="Arial,sans-serif" size="2"><o:p></o:p></font></p>
  <font face="Arial,sans-serif" size="2"></font></div>
  <font face="Arial,sans-serif" size="2"></font></blockquote>
</body>
</html>


Mime
View raw message