[ http://issues.apache.org/jira/browse/IBATIS-112?page=all ] Clinton Begin closed IBATIS-112: --------------------------------
> Use of $[ ]$ in an iterate tag that takes a java.util.List results in an error > ------------------------------------------------------------------------------ > > Key: IBATIS-112 > URL: http://issues.apache.org/jira/browse/IBATIS-112 > Project: iBatis for Java > Type: Bug > Versions: 2.0.9b > Environment: Unix SunOS 5.8, Oracel 9.2.0.4 / 8.1.7.4 > Reporter: Sam Abeyratne > Assignee: Brandon Goodin > Priority: Blocker > Fix For: 2.1.0 > > Hi, > I am getting an error when trying to use the $[]$ syntax in an iterate tag > that is being used to pass a java.util.List containing a list of database > names. Since the query needs database names, they need to be passed as > literal values. > The error I am getting: There is no READABLE property named '' in class > 'java.util.ArrayList' > Would you know of a time frame this may get fixed in? I would like to some > how stick with ibatis. > Thanks again for all your help!! > The sqlMap I am using: The list contains sids: database1, datbase2, > database3, etc. > <select id="queryInterfaceBacklogs_DUAL" > parameterClass="java.util.List" resultMap="interface_backlog_result" > cacheModel="interface_backlog_cache"> > select > interface_name as SYSTEM_NAME, > sum(backlog_val) as BACKLOG_VAL, > sum(backlog_last1) as BACKLOG_LAST1, > sum(backlog_last2) as BACKLOG_LAST2, > sum(backlog_last3) as BACKLOG_LAST3 > from > ( > <iterate open="(" close=")" conjunction="UNION ALL"> > select > a.interface_name, > sum(decode(i.BACKLOG_VAL,'',0,i.BACKLOG_VAL)) as BACKLOG_VAL, > sum(decode(i.BACKLOG_LAST1,'',0,i.BACKLOG_LAST1)) as BACKLOG_LAST1, > sum(decode(i.BACKLOG_LAST2,'',0,i.BACKLOG_LAST2)) as BACKLOG_LAST2, > sum(decode(i.BACKLOG_LAST3,'',0,i.BACKLOG_LAST3)) as BACKLOG_LAST3 > from INTERFACE_STATUS i, > ( select distinct interface_name > from [EMAIL PROTECTED] > where category='Provisioning' > )a > where SYSTEM_NAME is not null > and a.interface_name = i.system_name > group by a.interface_name > </iterate> > ) > group by interface_name > </select> > CacheModel and ResultMap: > <cacheModel id="interface_backlog_cache" type="MEMORY"> > <flushInterval minutes="1"/> > <flushOnExecute statement="queryInterfaceTimeline"/> > <property name="reference-type" value="WEAK"/> > </cacheModel> > <resultMap id="interface_backlog_result" class="pmt.InterfaceBacklog"> > <result property="systemName" column="system_name"/> > <result property="currentBacklog" column="backlog_val"/> > <result property="t1Backlog" column="backlog_last1"/> > <result property="t2Backlog" column="backlog_last2"/> > <result property="t3Backlog" column="backlog_last3"/> > </resultMap> -- 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