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.