<sql id="Top_MrcNrc_List" >
mrcnrc as
<iterate property="AllServiceOrderNames" open="(" close=" )," conjunction="UNION" >
select
so.process_instance_id,
so.customerorderrevenuemrc customerorderrevenuemrc,
so.customerorderrevenuenrc customerorderrevenuenrc
from $AllServiceOrderNames[]$ so
</iterate>
</sql><select id="IFCPendingOrdersReceived" resultClass="java.util.HashMap" parameterClass="java.util.Map"> with <include refid="Top_MrcNrc_List" />
orderDetails as(
<iterate property="secondLevelNames" open="" close="" conjunction="UNION" >
select wi.process_instance_id, wi.WORKITEM_ID,so.serviceorderid ORDERNUMBER,wi.performer ASSIGNED,od.customerorderrevenuenrc SUMOFNRCTOTAL
from $secondLevelNames[]$ so left join mrcnrc od on so.parentpiid=od.process_instance_id,workitem wi
where so.process_instance_id=wi.process_instance_id
</isNotNull>
and wi.status in ('I_AVAILABLE')
and wi.start_time is not null and wi.end_time is null
</iterate>
)
select ASSIGNED,to_char(sum(SUMOFNRCTOTAL)) SUMOFNRCTOTAL,to_char(count(*)) count
from orderDetails
group by ASSIGNED
</select>这样写有什么错呢,输出的错误为
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in SqlMap-SAS-Dashboard.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the SASDashboardSQLMap.IFCPendingOrdersReceived.
--- Check the parameter map.
--- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.NumberFormatException: For input string: ""
我传进来的AllServiceOrderNames是有值的
mrcnrc as
<iterate property="AllServiceOrderNames" open="(" close=" )," conjunction="UNION" >
select
so.process_instance_id,
so.customerorderrevenuemrc customerorderrevenuemrc,
so.customerorderrevenuenrc customerorderrevenuenrc
from $AllServiceOrderNames[]$ so
</iterate>
</sql><select id="IFCPendingOrdersReceived" resultClass="java.util.HashMap" parameterClass="java.util.Map"> with <include refid="Top_MrcNrc_List" />
orderDetails as(
<iterate property="secondLevelNames" open="" close="" conjunction="UNION" >
select wi.process_instance_id, wi.WORKITEM_ID,so.serviceorderid ORDERNUMBER,wi.performer ASSIGNED,od.customerorderrevenuenrc SUMOFNRCTOTAL
from $secondLevelNames[]$ so left join mrcnrc od on so.parentpiid=od.process_instance_id,workitem wi
where so.process_instance_id=wi.process_instance_id
</isNotNull>
and wi.status in ('I_AVAILABLE')
and wi.start_time is not null and wi.end_time is null
</iterate>
)
select ASSIGNED,to_char(sum(SUMOFNRCTOTAL)) SUMOFNRCTOTAL,to_char(count(*)) count
from orderDetails
group by ASSIGNED
</select>这样写有什么错呢,输出的错误为
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in SqlMap-SAS-Dashboard.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the SASDashboardSQLMap.IFCPendingOrdersReceived.
--- Check the parameter map.
--- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.NumberFormatException: For input string: ""
我传进来的AllServiceOrderNames是有值的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货