Java Mailing List Archive

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

Home » user-java.ibatis »

Re: iBatis 3: dynamic sql and numeric property type problem

Andreas Niemeyer

2010-05-31

Replies: Find Java Web Hosting

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

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