Capability to use dynamic sql within iterates
---------------------------------------------
Key: IBATIS-148
URL: http://issues.apache.org/jira/browse/IBATIS-148
Project: iBatis for Java
Type: Improvement
Components: SQL Maps
Versions: 2.1.0, 2.0.9b
Reporter: Sam Abeyratne
I am getting the following error when I try to run a simple query that has a
dynamic <isNotEqual> within an iterate tag. Per Brandon, this is a known issue
that needs to be fixed.
Thanks!
Sam
2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class -
Parameters: {sidList=[abc1, abc2], carrier=ABCDE1, interfaceType=DSP}
2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class - Calling
queryForList with statementName: queryInterfaceErrorCount and parameters:
{sidList=[abc1, abc2], carrier= ABCDE1, interfaceType=DSP}
2005-06-06 17:11:25,294 [HttpRequestHandler-2083] ERROR xxxDispatchAction.class
- Entered catch block in viewErrorLog: Exception in queryInterfaceErrorCount:
com.ibatis.common.beans.ProbeException: Error getting ordinal list from
JavaBean. Cause java.lang.NumberFormatException: For input string: "" Caused
by: java.lang.NumberFormatException: For input string: ""
The sqlmap looks something like:
<select id="queryInterfaceErrorCount" parameterClass="java.util.Map"
resultMap="interface_error_count_result"
cacheModel="interface_error_count_cache">
select sum(count) as count
from
(
<iterate property="sidList" open="(" close=")" conjunction="UNION ALL">
select count(*) as count
from [EMAIL PROTECTED]
where interface_type = #interfaceType#
<isNotEqual prepend="and" property="carrier" compareValue="All">
carrier_name = #carrier#
</isNotEqual>
</iterate>
)
</select>
Java bean looks like:
public class InterfaceErrorCount {
private int count;
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
}
--
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
