You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "aaron pieper (JIRA)" <ib...@incubator.apache.org> on 2008/12/03 16:07:44 UTC
[jira] Created: (IBATIS-557) Error referencing iterable fields as
properties of a dynamic SQL statement
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.
[jira] Commented: (IBATIS-557) Error referencing iterable fields as
properties of a dynamic SQL statement
Posted by "Jeff Butler (JIRA)" <ib...@incubator.apache.org>.
[ 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.