IBatis: How to iterate a integer list within a list of objects

[Steve]

Hi

  I need help to be able to iterate in a objects list and iterate within it on a list of integer.

  The parameterClass is a list of object that contains the attributes "startDate" and a list of "ids"

<select id="mySelectId" resultClass="java.lang.Integer" parameterClass="java.util.List">

SELECT myInteger

FROM myTable

WHERE 

    <iterate open="(" close=")" conjunction=" OR ">

    startDate = #[].startDate#  AND

 id IN <iterate  property="ids" open="(" close=")" conjunction=",">#[].ids[]#</iterate>

        </iterate>

        </select>

com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.StringIndexOutOfBoundsException: String index out of range: -1

at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:86)

at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:54)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.elements.IterateTagHandler.doStartFragment(IterateTagHandler.java:47)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.DynamicSql.processBodyChildren(DynamicSql.java:156)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.DynamicSql.processBodyChildren(DynamicSql.java:159)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.DynamicSql.processBodyChildren(DynamicSql.java:98)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.DynamicSql.process(DynamicSql.java:78)

at com.ibatis.sqlmap.engine.mapping.sql.dynamic.DynamicSql.getSql(DynamicSql.java:51)

at com.xyz.price.impl.PriceDescriptionIBatisXmlTest.getSql(PriceDescriptionIBatisXmlTest.java:143)

at com.xyz.price.impl.PriceDescriptionIBatisXmlTest.test(PriceDescriptionIBatisXmlTest.java:121)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)

at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)

at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)

at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)

at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)

at org.junit.runners.ParentRunner.run(ParentRunner.java:220)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1

at java.lang.String.substring(String.java:1937)

at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:50)

... 33 more

Thanks for your help.

[Steve]

I found the solution, I change the parameter class to a Map:

<select id="mySelectId" resultClass="java.lang.Integer" parameterClass="java.util.Map">

SELECT myInteger

FROM myTable

WHERE 

<iterate property="criteriaList" open="(" close=")" conjunction=" OR ">

(id IN

<iterate property="criteriaList[].serviceIdList" open="(" close=")" conjunction=",">   

#criteriaList[].serviceIdList[]#

</iterate>

)

</iterate>

</select>

Voilà!