headers
Andreas Niemeyer | 31 May 2010 16:55
Picon
Favicon

iBatis 3: dynamic sql and numeric property type problem

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
Permalink | Reply |
headers
Larry Meadors | 31 May 2010 18:10
Picon
Gravatar

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

I think you can just say <if test="id != -1">, but I haven't done this
exact thing yet.

Since we're using ognl for expressions, here's where I'd look:
http://www.opensymphony.com/ognl/html/LanguageGuide/index.html

Also, you should join and post to the new list at google:
http://groups.google.com/group/mybatis-user instead.

At this point, there are no plans to continue the ibatis project at
Apache, the project (including the development team) has moved and it
will live on as mybatis at google code instead.

Larry
Permalink | Reply |
headers
Andreas Niemeyer | 31 May 2010 18:12
Picon
Favicon

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

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       
>
(Continue reading)

Permalink | Reply |
headers
Andreas Niemeyer | 7 Jun 2010 12:57
Picon
Favicon

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

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,
>>
(Continue reading)

Permalink | Reply |
headers
Larry Meadors | 7 Jun 2010 13:56
Picon
Gravatar

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

The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

Larry
Permalink | Reply |

Gmane