[ http://issues.apache.org/jira/browse/IBATIS-148?page=comments#action_12315187 ]
Sam Abeyratne commented on IBATIS-148: -------------------------------------- It works now! Brandon and Manfred, thank you very much for helping us out on this bug. Again, all of us here truly appreciate your efforts in resolving issues and providing timely responses to our questions. It has been a pleasant experience working with iBatis and the iBatis team! Batman will try to lay low for a while now :-) Thanks again! Sam > 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 [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
