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-06-07

Replies: Find Java Web Hosting

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

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