ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Niemeyer <nieme...@freenet.de>
Subject iBatis 3: dynamic sql and numeric property type problem
Date Mon, 31 May 2010 14:55:35 GMT
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


Mime
View raw message