Return-Path: 
 <user-java-return-12786-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 1259 invoked from network); 12 Oct 2007 02:43:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Oct 2007 02:43:59 -0000
Received: (qmail 41103 invoked by uid 500); 12 Oct 2007 02:43:40 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 41085 invoked by uid 500); 12 Oct 2007 02:43:40 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 41074 invoked by uid 99); 12 Oct 2007 02:43:40 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Oct 2007 19:43:40 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of jeffgbutler@gmail.com
 designates 209.85.146.181 as permitted sender)
Received: from [209.85.146.181] (HELO wa-out-1112.google.com) (209.85.146.181)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Oct 2007 02:43:44 +0000
Received: by wa-out-1112.google.com with SMTP id j5so1203312wah
        for <user-java@ibatis.apache.org>;
 Thu, 11 Oct 2007 19:43:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        bh=OGel2YukbtbBwxDdfbhgMw4OQz2WUpO3lD9JnGKN7bA=;
        b=hmLTZjkV21LvhB7RZbM3A3e5i1F2IyBEcCFKhBjUVKjwn2CvRM1jN/tXnPbCWp12KqAUbZKA/Z0w8IRd2poiPij+0LSQ6E8w8Vft0XcReKlQLn3WM1oPtThkV+u+zse+1lHzLZqOPn7lehJVO+Bu9//2iD/BVEaE3AFigXDNsbI=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=BCpDOH4i96qtrKYGBijQ0Iau9mN3txKCigd3reRmQ8ZZrOC3RIX92M9qSP+YF/jBhToWRsqwbZKjxL+Py8B0y3FGwjyj1fO5W7XY96orNHpQ6/wQA0BvZ/UgVMprsx7qkmuDGz0aDVOBIorg+nBlIIYieFV87aSHUMRgp9Csqf4=
Received: by 10.114.192.1 with SMTP id p1mr2966485waf.1192157002739;
        Thu, 11 Oct 2007 19:43:22 -0700 (PDT)
Received: by 10.115.111.12 with HTTP; Thu, 11 Oct 2007 19:43:22 -0700 (PDT)
Message-ID: <c593b8750710111943s4f9b83bcx422d4fcf6d1739eb@mail.gmail.com>
Date: Thu, 11 Oct 2007 21:43:22 -0500
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: IBATIS-459 SQLMAP BUG
In-Reply-To: <905277030710111859q5baa838fgd124b2dc159019b4@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_19293_18467940.1192157002731"
References: <905277030710111859q5baa838fgd124b2dc159019b4@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_19293_18467940.1192157002731
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

IBATIS-459 was not a bug - it was an improper use of JIRA.  It probably
should have been closed as "invalid" rather than "fixed".

For your issue, specify remapResults="true" in your <select> element.

Jeff Butler


On 10/11/07, dereje abay <derejea@gmail.com> wrote:
>
>  Hi Guys,
>
> I am using IBATIS release 2.3.0.67 in my project. I am getting the same
> bug filed as
> IBATIS-459.
>
> "the second consecutive dynamic select statement is incorrectly using
> values from the first dynamic select statement"
>
> Here is the scenario.
>
> <
> select id=" getRecords" resultClass ="xml" xmlResultName ="result"
> parameterClass ="AUITableInfo">
>
> select
> <iterate conjunction="," property="inputList" >
>
> $inputList[].name$
>
> </iterate>
>
> from $tableName$
>
> where $fieldName$$operator$#value#
>
> </
> select>
>
> If you call getRecords twice for tables x and y, the first request will
> return result. But the second request throws exception by saying "invalid
> column name for table X". If you reverse the order (i.e call y first and x
> second), y will get the response and x throws exception by referring
> "invalid column name for table Y"
>
> Bug # IBATIS-459  shows  as closed bug. Which release has this bug fix? .
> I download the latest release but still am getting the same error.
>
> By the way, am using Spring with IBATIS.
>
> I really appreciate your help.
> Regards,
> Dereje Yimam
>

------=_Part_19293_18467940.1192157002731
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>IBATIS-459 was not a bug - it was an improper use of JIRA.&nbsp; It probably should have been closed as &quot;invalid&quot; rather than &quot;fixed&quot;.</div>
<div>&nbsp;</div>
<div>For your issue, specify remapResults=&quot;true&quot; in your &lt;select&gt; element.</div>
<div>&nbsp;</div>
<div>Jeff Butler<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 10/11/07, <b class="gmail_sendername">dereje abay</b> &lt;<a href="mailto:derejea@gmail.com">derejea@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div><font face="Helv" size="2">
<p>Hi Guys, </p>
<p>I am using IBATIS release <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://2.3.0.67/" target="_blank">2.3.0.67</a> in my project. I am getting the same bug filed as </p></font><font face="Helv" color="#0000ff" size="2">
IBATIS-459. </font><font face="Helv" size="2">
<p>&quot;the second consecutive dynamic select statement is incorrectly using values from the first dynamic select statement&quot;</p>
<p>Here is the scenario. </p></font><font face="Courier New" color="#0000ff" size="2">
<p>&lt;</p></font><font face="Courier New" color="#a11f12" size="2">select</font><font face="Courier New" size="2"> </font><font face="Courier New" color="#ff0000" size="2">id</font><font face="Courier New" size="2">=&quot; 
</font><font face="Courier New" color="#0000ff" size="2">getRecords</font><font face="Courier New" size="2">&quot; </font><font face="Courier New" color="#ff0000" size="2">resultClass</font><font face="Courier New" size="2">
 =&quot;</font><font face="Courier New" color="#0000ff" size="2">xml</font><font face="Courier New" size="2">&quot; </font><font face="Courier New" color="#ff0000" size="2">xmlResultName</font><font face="Courier New" size="2">
 =&quot;</font><font face="Courier New" color="#0000ff" size="2">result</font><font face="Courier New" size="2">&quot; </font><font face="Courier New" color="#ff0000" size="2">parameterClass</font><font face="Courier New" size="2">
 =&quot;</font><font face="Courier New" color="#0000ff" size="2">AUITableInfo</font><font face="Courier New" size="2">&quot;</font><font face="Courier New" color="#0000ff" size="2">&gt;</font><font face="Courier New" size="2">
 
<p>select </p></font><font face="Courier New" color="#0000ff" size="2">&lt;</font><font face="Courier New" color="#a11f12" size="2">iterate</font><font face="Courier New" size="2"> </font><font face="Courier New" color="#ff0000" size="2">
conjunction</font><font face="Courier New" size="2">=&quot;</font><font face="Courier New" color="#0000ff" size="2">,</font><font face="Courier New" size="2">&quot; </font><font face="Courier New" color="#ff0000" size="2">
property</font><font face="Courier New" size="2">=&quot;</font><font face="Courier New" color="#0000ff" size="2">inputList</font><font face="Courier New" size="2">&quot;</font><font face="Courier New" color="#0000ff" size="2">
 &gt;</font><font face="Courier New" size="2"> 
<p>$inputList[].name$ </p>
<p></p></font><font face="Courier New" color="#0000ff" size="2">&lt;/</font><font face="Courier New" color="#a11f12" size="2">iterate</font><font face="Courier New" color="#0000ff" size="2">&gt;</font><font face="Courier New" size="2">
 
<p></p>
<p>from $tableName$</p>
<p>where $fieldName$$operator$#value#</p></font><font face="Courier New" color="#0000ff" size="2">
<p>&lt;/</p></font><font face="Courier New" color="#a11f12" size="2">select</font><font face="Courier New" color="#0000ff" size="2">&gt;</font><font face="Courier New" size="2"> </font><font face="Helv" size="2">
<p>If you call getRecords twice for tables x and y, the first request will return result. But the second request throws exception by saying &quot;invalid column name for table X&quot;. If you reverse the order (i.e call y first and x second), y will get the response and x throws exception by referring &quot;invalid column name for table Y&quot; 
</p>
<p></p></font><font face="Helv" color="#0000ff" size="2">Bug # IBATIS-459&nbsp;</font><font face="Helv" size="2">&nbsp;shows&nbsp; as closed&nbsp;bug.&nbsp;Which release has this bug fix? . I download the latest release but still am getting the same error. 
<p>By the way, am using Spring with IBATIS. </p>
<p>I really appreciate your help. </p>
<div>Regards,</div></font><font face="Tms Rmn"></font>
<div><font face="Tms Rmn">Dereje Yimam</font></div></div></blockquote></div><br>

------=_Part_19293_18467940.1192157002731--