Return-Path: 
 <user-java-return-19436-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 85645 invoked from network); 7 Jun 2010 10:57:49 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Jun 2010 10:57:49 -0000
Received: (qmail 2276 invoked by uid 500); 7 Jun 2010 10:57:48 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 2176 invoked by uid 500); 7 Jun 2010 10:57:46 -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 2169 invoked by uid 99); 7 Jun 2010 10:57:46 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Jun 2010 10:57:46 +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, 07 Jun 2010 10:57:38 +0000
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <gcjiu-ibatis-user-java@m.gmane.org>)
	id 1OLa14-0005vp-H4
	for user-java@ibatis.apache.org; Mon, 07 Jun 2010 12:57:14 +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, 07 Jun 2010 12:57:14 +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, 07 Jun 2010 12:57:14 +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, 07 Jun 2010 12:57:02 +0200
Lines: 58
Message-ID: <huij9v$l2t$1@dough.gmane.org>
References: <hu0il8$s97$1@dough.gmane.org> <hu0n4i$e6l$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: <hu0n4i$e6l$1@dough.gmane.org>
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,
I've another use case for a possible if check:

- if the parameterType long it fails for the if check:

<select id="getMegaList" resultType="Mega" parameterType="long"> 		
    Select
    	id, descr, description from mega_t
    <where>
    	<if test="id != -1">
		id = #{id}
	</if>
    </where>	
  </select>


Thank you in advance,
Andreas



Andreas Niemeyer schrieb:
> 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