You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Brandon Goodin (JIRA)" <ib...@incubator.apache.org> on 2005/04/19 05:39:44 UTC
[jira] Assigned: (IBATIS-112) Use of $[ ]$ in an iterate tag that takes a java.util.List results in an error
[ http://issues.apache.org/jira/browse/IBATIS-112?page=all ]
Brandon Goodin reassigned IBATIS-112:
-------------------------------------
Assign To: Brandon Goodin
> 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
>
> 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 interface@$[]$
> 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