Return-Path: 
 <ibatis-user-java-return-2657-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 10918 invoked from network); 7 Jun 2005 03:19:53 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 7 Jun 2005 03:19:53 -0000
Received: (qmail 11693 invoked by uid 500); 7 Jun 2005 03:19:52 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 11675 invoked by uid 500); 7 Jun 2005 03:19:52 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 11660 invoked by uid 99); 7 Jun 2005 03:19:52 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com
 designates 64.233.170.194 as permitted sender)
Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.194)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 06 Jun 2005 20:19:50 -0700
Received: by rproxy.gmail.com with SMTP id c16so2574486rne
        for <ibatis-user-java@incubator.apache.org>;
 Mon, 06 Jun 2005 20:19:43 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=aokzSxfsBi4/Q5K6qOpux6zdVOpwzihcxwP42t0sZI064DsIs3lD+dr2byXdxZ/eQo1KA9x9mBNUugKvLlViEND0MUKGNx5PRky9BmtqiAx0vwl1IvRWHZynzjiXBXY2mkF3vvGGUSRH8AaogBf5neDlhG/FFuQJJBXl9cV+cTg=
Received: by 10.38.207.45 with SMTP id e45mr2202681rng;
        Mon, 06 Jun 2005 20:19:43 -0700 (PDT)
Received: by 10.38.74.48 with HTTP; Mon, 6 Jun 2005 20:19:43 -0700 (PDT)
Message-ID: <2fe5ef5b050606201977f7aa2f@mail.gmail.com>
Date: Mon, 6 Jun 2005 21:19:43 -0600
From: Brandon Goodin <brandon.goodin@gmail.com>
Reply-To: Brandon Goodin <brandon.goodin@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: dynamic sql within an iterate tag
In-Reply-To: 
 <2FAA57A6845C664880384825E92D6AC901A82371@WA-MSG06-BTH.wireless.attws.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <2FAA57A6845C664880384825E92D6AC901A82371@WA-MSG06-BTH.wireless.attws.com>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Sam,

Sorry, I meant to respond to you in your prior email. Currently this
is not supported. But, we do want it to work. So, please file a JIRA
report. I'll work on it this evening and see if i can get the fix in
tonight.

Brandon

On 6/6/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> =20
> =20
>=20
> Hey All,=20
>=20
>  =20
>=20
> I had asked this question before, but I didn't get an answer, so I am
> re-posting this question:=20
>=20
>  =20
>=20
> I am getting the following error when I try to run a simple query that ha=
s a
> dynamic <isNotEqual> within an iterate tag. Can you tell me if this is ev=
en
> possible to do in iBatis?=20
>=20
>  =20
>=20
> Thanks in advance for your assistance!=20
>=20
> Sam=20
>=20
>  =20
>=20
>  =20
>=20
> 2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class -
> Parameters: {sidList=3D[abc1, abc2], carrier=3DABCDE1, interfaceType=3DDS=
P}=20
>=20
> =20
>=20
> 2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class -
> Calling queryForList with statementName: queryInterfaceErrorCount and
> parameters: {sidList=3D[abc1, abc2], carrier=3D ABCDE1, interfaceType=3DD=
SP}=20
>=20
> =20
>=20
> 2005-06-06 17:11:25,294 [HttpRequestHandler-2083] ERROR
> xxxDispatchAction.class - Entered catch block in viewErrorLog: Exception =
in
> queryInterfaceErrorCount:
> com.ibatis.common.beans.ProbeException: Error getting
> ordinal list from JavaBean. Cause java.lang.NumberFormatException: For in=
put
> string: "" Caused by: java.lang.NumberFormatException: For input string: =
""=20
>=20
> =20
>=20
> The sqlmap looks something like:=20
>=20
>  =20
>=20
>     <select id=3D"queryInterfaceErrorCount" parameterClass=3D"java.util.M=
ap"
> resultMap=3D"interface_error_count_result"
> cacheModel=3D"interface_error_count_cache">=20
>=20
>     select sum(count) as count=20
>=20
>     from=20
>=20
>     (=20
>=20
>       <iterate property=3D"sidList" open=3D"(" close=3D")" conjunction=3D=
"UNION
> ALL">=20
>=20
>         select count(*) as count=20
>=20
>           from mim_error_log@$sidList[]$=20
>=20
>         where interface_type =3D #interfaceType#=20
>=20
>         <isNotEqual prepend=3D"and" property=3D"carrier" compareValue=3D"=
All"> =20
>=20
>           carrier_name =3D #carrier# =20
>=20
>         </isNotEqual>=20
>=20
>       </iterate>=20
>=20
>     )=20
>=20
>   </select>=20
>=20
>  =20
>=20
> Java bean looks like:=20
>=20
>  =20
>=20
> public class InterfaceErrorCount  {=20
>=20
>  =20
>=20
>   private int count;=20
>=20
>  =20
>=20
>   public int getCount() {=20
>=20
>     return count;=20
>=20
>   }=20
>=20
>  =20
>=20
>   public void setCount(int count)  {=20
>=20
>     this.count =3D count;=20
>=20
>   }=20
>=20
> }