[ http://issues.apache.org/jira/browse/IBATIS-111?page=all ]
Brandon Goodin closed IBATIS-111:
---------------------------------
Resolution: Duplicate
IBATIS-112 was the same
> Use of $[ ]$ passing a java.util.List within an iterate of literal values
> results in error
> ------------------------------------------------------------------------------------------
>
> Key: IBATIS-111
> URL: http://issues.apache.org/jira/browse/IBATIS-111
> Project: iBatis for Java
> Type: Bug
> Versions: 2.0.9b
> Environment: Unix - SunOS 5.8, Oracle 8.1.7.4 or 9.2.0.4,
> java/jsp/servlet/xml based software
> Reporter: Sam Abeyratne
> Priority: Blocker
>
> Hi,
> I am trying to use the iterate tag passing a list of database names. since
> these are database names, I need them to be used as literal values. However,
> using $[]$ results in an error: There is no READABLE property named '' in
> > class 'java.util.ArrayList'
> Here is the code I am using (However, any simple query ahould also return you
> the same error):
> <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>
--
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
