Turn on logging (see iBatis docs) to see what does the generated SQL
statement look like.
On Fri, Jun 19, 2009 at 7:34 AM, BruceKKK <sibyl0...@gmail.com> wrote:
>
> 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
> --
> View this message in context:
> http://www.nabble.com/issue-of-ibatis-sqlmap-list-of-list-tp24105006p24105006.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
