From user-java-return-19424-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org Mon May 31 16:12:43 2010
Return-Path: <user-java-return-19424-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 17451 invoked from network); 31 May 2010 16:12:43 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 31 May 2010 16:12:43 -0000
Received: (qmail 8228 invoked by uid 500); 31 May 2010 16:12:43 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 8199 invoked by uid 500); 31 May 2010 16:12:43 -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 8192 invoked by uid 99); 31 May 2010 16:12:43 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 16:12:43 +0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=FREEMAIL_FROM,SPF_HELO_PASS,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of gcjiu-ibatis-user-java@m.gmane.org designates 80.91.229.12 as permitted sender)
Received: from [80.91.229.12] (HELO lo.gmane.org) (80.91.229.12)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 16:12:35 +0000
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <gcjiu-ibatis-user-java@m.gmane.org>)
	id 1OJ7b1-0004mJ-V2
	for user-java@ibatis.apache.org; Mon, 31 May 2010 18:12:11 +0200
Received: from fwo.gutzmann.com ([217.6.22.218])
        by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <user-java@ibatis.apache.org>; Mon, 31 May 2010 18:12:11 +0200
Received: from niemeand by fwo.gutzmann.com with local (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <user-java@ibatis.apache.org>; Mon, 31 May 2010 18:12:11 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: user-java@ibatis.apache.org
connect(): No such file or directory
From: Andreas Niemeyer <niemeand@freenet.de>
Subject: Re: iBatis 3: dynamic sql and numeric property type problem
Date: Mon, 31 May 2010 18:12:02 +0200
Lines: 39
Message-ID: <hu0n4i$e6l$1@dough.gmane.org>
References: <hu0il8$s97$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: fwo.gutzmann.com
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; de; rv:1.8.1.24) Gecko/20100228 Thunderbird/2.0.0.24 Mnenhy/0.7.5.0
In-Reply-To: <hu0il8$s97$1@dough.gmane.org>
X-Virus-Checked: Checked by ClamAV on apache.org

Sorry, I had a missunderstanding, it works this way:

...
<if test="id != -1">
	and x.id = #{id} 	
</if>	
...

Andreas Niemeyer schrieb:
> Hi,
> 
> how can I deal with numeric class properties for dynamic sql in iBatis 
> 3.x? In the older 2.x release there exist a `<isGreaterThan>' tag and 
> the user guide for 3.x only mentioned the <if> condition. For that, I 
> get a NumberFormatException:
> 
> Caused by: java.lang.NumberFormatException: For input string: "{0=null}"
> 
> 
> The example looks like:
> 
> <select id="getSomeList" resultType="SomeClass" 
> parameterType="SomeConditionClass">
>          select
>             <include refid="someColumns"/>
>         from
>             hmm_t t, context_x x
>         where
>             t.id = x.id_hmm       
>            
>             <if test="#{id} != -1">
>                 and x.id = #{id}    
>             </if>   
>            
> </select>
> 
> 
> Thank you in advance,
> Andreas


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org