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
