ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai Grabfelder <nos...@kaigrabfelder.de>
Subject Re: issue of ibatis sqlmap list of list
Date Fri, 19 Jun 2009 06:14:10 GMT
consider using a tmp table if you encounter this error (a) insert into tmp table, b) join your
select with the
tmp table). Most of the time ist should be faster than doing than combining OR and IN statements.

cheers

Kai

--- Original Nachricht ---
Absender: BruceKKK
Datum: 19.06.2009 05:34
> i met ora-01795 error, so i need separate list to several size limited lists,
> I am trying use nested iterators to iterate over a List of List  using
> following code:
> 
> <select id="getList" parameterClass="map" resultClass="com.ResultObject">	 
>  select *****	from ****** where 
>   <isNotEmpty property="outLists" >
>    <iterate property="outLists" open="(" close=")" conjunction="OR">
>     data in
>      <iterate property="outLists[]" open="(" close=")" conjunction=",">
>       #outLists[].[]#
>      </iterate>
>     </iterate>
>    </isNotEmpty>
> </select>
> 
> but i got exception:
> com.ibatis.common.beans.ProbeException: Error getting ordinal list from
> JavaBean. Cause java.lang.NumberFormatException: For input string: "" 
> 
> how to make it run?
> 
> by the way: the version of ibatis i used is 2.1.7


Mime
View raw message