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.
