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
