You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Larry Meadors (JIRA)" <ib...@incubator.apache.org> on 2005/09/28 14:05:48 UTC
[jira] Closed: (IBATIS-199) subsequent calls to queryForList of select with iterate element still remembers number of entries from first call
[ http://issues.apache.org/jira/browse/IBATIS-199?page=all ]
Larry Meadors closed IBATIS-199:
--------------------------------
Resolution: Invalid
Changing the number of selected fields requires use ot remapResults="true" in the select tag.
> subsequent calls to queryForList of select with iterate element still remembers number of entries from first call
> -----------------------------------------------------------------------------------------------------------------
>
> Key: IBATIS-199
> URL: http://issues.apache.org/jira/browse/IBATIS-199
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.1.5
> Environment: 2.1.5, jdk 1.4.2_04, windows XP, Tomcat 5.0, Oracle 9i
> Reporter: Bill Frost
>
> Calling the statement below with 10 elements in the SCORE LinkedList works OK and returns perfect results.
> Calling it a second time with 30 elements in the SCORE LinkedList returns different results, but the iterate behaves as if there were still only 10 elements in SCORE.
> <select id="ScoreDistributionForTag" parameterClass="java.util.Map" resultClass="java.util.LinkedHashMap">
> select tag,
> <dynamic>
> <isNotNull property="SCORE">
> <iterate property="SCORE" conjunction=", ">count(case when value = #SCORE[]# then 1 end) "$SCORE[]$" </iterate>
> </isNotNull>
> </dynamic>
> from score where marked is not null and criteria = '*' and itemtype = 'S'
> <dynamic>
> <isNotNull prepend="AND" property="TAG"> tag = #TAG# </isNotNull>
> </dynamic>
> group by tag
> </select>
> Could the statement have been prepared somewhere and re-used?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira