Java Mailing List Archive

http://www.java2.5341.com/

Home » user-java.ibatis »

iBatis 3: dynamic sql and numeric property type problem

Andreas Niemeyer

2010-05-31

Replies: Find Java Web Hosting

Author LoginPost Reply
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@(protected)
For additional commands, e-mail: user-java-help@(protected)

©2008 java2.5341.com - Jax Systems, LLC, U.S.A.