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/07/05 16:02:10 UTC
[jira] Closed: (IBATIS-148) Capability to use dynamic sql within iterates
[ http://issues.apache.org/jira/browse/IBATIS-148?page=all ]
Brandon Goodin closed IBATIS-148:
---------------------------------
Fix Version: 2.1.5
Resolution: Fixed
issue should now be completely fixed.
> 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.0.9b, 2.1.0
> Reporter: Sam Abeyratne
> Assignee: Brandon Goodin
> Fix For: 2.1.5
>
> 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 mim_error_log@$sidList[]$
> 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