You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Michel Cabral do Amaral (JIRA)" <ib...@incubator.apache.org> on 2007/08/27 20:03:33 UTC
[jira] Created: (IBATIS-454) Dynamic sql map with java.util.List
Dynamic sql map with java.util.List
-----------------------------------
Key: IBATIS-454
URL: https://issues.apache.org/jira/browse/IBATIS-454
Project: iBatis for Java
Issue Type: Bug
Components: SQL Maps
Affects Versions: 2.1.7
Environment: Database - Oracle 10g
Reporter: Michel Cabral do Amaral
Priority: Minor
When I use parameterClass of java.util.List type with dynamic notation ($[].field$), the property (after dot) is ignored and the toString method of the current list element is called instead of the indicated property, for example, the follow statement map is calling toString twice:
<select id="<statement id>" remapResults="true" resultMap="<result map name>"
parameterClass="java.util.List">
SELECT <cols>
FROM <clause>
<dynamic prepend="WHERE">
<iterate conjunction="AND">
$[].field$ $[].operator$ #[].value#
</iterate>
</dynamic>
</select>
I´m using version 2.1.7 build 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-454) Dynamic sql map with java.util.List
Posted by "Michel Cabral do Amaral (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523142 ]
Michel Cabral do Amaral commented on IBATIS-454:
------------------------------------------------
Yes, I tried to use 2.3.0 version with DAO framework 2.2.0. Some methods are deprecated (like queryForPaginatedList), but it works. However, did not solve the issue. :-(
> Dynamic sql map with java.util.List
> -----------------------------------
>
> Key: IBATIS-454
> URL: https://issues.apache.org/jira/browse/IBATIS-454
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7
> Environment: Database - Oracle 10g
> Reporter: Michel Cabral do Amaral
> Priority: Minor
>
> When I use parameterClass of java.util.List type with dynamic notation ($[].field$), the property (after dot) is ignored and the toString method of the current list element is called instead of the indicated property, for example, the follow statement map is calling toString twice:
>
> <select id="<statement id>" remapResults="true" resultMap="<result map name>"
> parameterClass="java.util.List">
> SELECT <cols>
> FROM <clause>
> <dynamic prepend="WHERE">
> <iterate conjunction="AND">
> $[].field$ $[].operator$ #[].value#
> </iterate>
> </dynamic>
> </select>
> I´m using version 2.1.7 build 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-454) Dynamic sql map with java.util.List
Posted by "Brandon Goodin (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523096 ]
Brandon Goodin commented on IBATIS-454:
---------------------------------------
Please upgrade to the most current iBATIS release and see if that resolves it. I know we have made changes since 2.1.7. Let us know if it works after you upgrade.
> Dynamic sql map with java.util.List
> -----------------------------------
>
> Key: IBATIS-454
> URL: https://issues.apache.org/jira/browse/IBATIS-454
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7
> Environment: Database - Oracle 10g
> Reporter: Michel Cabral do Amaral
> Priority: Minor
>
> When I use parameterClass of java.util.List type with dynamic notation ($[].field$), the property (after dot) is ignored and the toString method of the current list element is called instead of the indicated property, for example, the follow statement map is calling toString twice:
>
> <select id="<statement id>" remapResults="true" resultMap="<result map name>"
> parameterClass="java.util.List">
> SELECT <cols>
> FROM <clause>
> <dynamic prepend="WHERE">
> <iterate conjunction="AND">
> $[].field$ $[].operator$ #[].value#
> </iterate>
> </dynamic>
> </select>
> I´m using version 2.1.7 build 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-454) Dynamic sql map with java.util.List
Posted by "Brandon Goodin (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523121 ]
Brandon Goodin commented on IBATIS-454:
---------------------------------------
I believe it should work. Have you tried it?
> Dynamic sql map with java.util.List
> -----------------------------------
>
> Key: IBATIS-454
> URL: https://issues.apache.org/jira/browse/IBATIS-454
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7
> Environment: Database - Oracle 10g
> Reporter: Michel Cabral do Amaral
> Priority: Minor
>
> When I use parameterClass of java.util.List type with dynamic notation ($[].field$), the property (after dot) is ignored and the toString method of the current list element is called instead of the indicated property, for example, the follow statement map is calling toString twice:
>
> <select id="<statement id>" remapResults="true" resultMap="<result map name>"
> parameterClass="java.util.List">
> SELECT <cols>
> FROM <clause>
> <dynamic prepend="WHERE">
> <iterate conjunction="AND">
> $[].field$ $[].operator$ #[].value#
> </iterate>
> </dynamic>
> </select>
> I´m using version 2.1.7 build 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-454) Dynamic sql map with java.util.List
Posted by "Michel Cabral do Amaral (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523111 ]
Michel Cabral do Amaral commented on IBATIS-454:
------------------------------------------------
I'm using version 2.2.0 build 638 now, but the problem remains.
I can't upgrade it to 2.3.0 version cause I'm using DAO framework that is not supported by this version, and I'm using it :-(
Issues related to old version will be fixed?
> Dynamic sql map with java.util.List
> -----------------------------------
>
> Key: IBATIS-454
> URL: https://issues.apache.org/jira/browse/IBATIS-454
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.1.7
> Environment: Database - Oracle 10g
> Reporter: Michel Cabral do Amaral
> Priority: Minor
>
> When I use parameterClass of java.util.List type with dynamic notation ($[].field$), the property (after dot) is ignored and the toString method of the current list element is called instead of the indicated property, for example, the follow statement map is calling toString twice:
>
> <select id="<statement id>" remapResults="true" resultMap="<result map name>"
> parameterClass="java.util.List">
> SELECT <cols>
> FROM <clause>
> <dynamic prepend="WHERE">
> <iterate conjunction="AND">
> $[].field$ $[].operator$ #[].value#
> </iterate>
> </dynamic>
> </select>
> I´m using version 2.1.7 build 597
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.