[
https://issues.apache.org/jira/browse/IBATIS-557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12652829#action_12652829
]
Jeff Butler commented on IBATIS-557:
------------------------------------
Please try iBATIS version 2.2 or higher. We did not support nested iterables
until that version and we made a lot of improvements in how the tags worked.
> Error referencing iterable fields as properties of a dynamic SQL statement
> --------------------------------------------------------------------------
>
> Key: IBATIS-557
> URL: https://issues.apache.org/jira/browse/IBATIS-557
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7
> Reporter: aaron pieper
>
> iBatis is throwing an exception when I try to use an iterable field as the
> property to a nested isNull or isNotNull statement. My SQL map looks
> something like this:
> ------------------------------------------------------------
> SELECT *
> FROM foo
> WHERE
> <iterate property="searchCriteria" conjunction=" OR ">
> <isNotNull property="searchCriteria[]">
> foo.bar=#searchCriteria[]#
> </isNotNull>
> <isNull property="searchCriteria[]">
> foo.bar is null
> </isNull>
> </iterate>
> ------------------------------------------------------------
> This produces a NumberFormatException, caused by "searchCriteria[]" being
> specified as a property. If I change the property to "searchCriteria"
> (without the braces) instead, then I don't get the exception (but the
> resulting behavior is incorrect.)
> This looks similar to the tracker IBATIS-42
> (http://issues.apache.org/jira/browse/IBATIS-42) but that particular tracker
> was marked as fixed in version 2.1.0, and I'm still seeing this problem in
> 2.1.7.597.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
