普元EOS中使用命名SQL查询报错

Question

报错内容就是说我写的命名SQL文件未在sqlmap中声明
Caused by: com.primeton.das.sql.impl.ibatis.sqlmap.client.SqlMapException: There is no statement named com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata in this SqlMap.
下面是我的命名sql文件：<?xml version="1.0" encoding="UTF-8"?>
<!-- author:jontel -->
<sqlMap>
    <parameterMap class="commonj.sdo.DataObject" id="parameterMap">
        <parameter javaType="String" jdbcType="varchar2" property="branch"/>
        <parameter javaType="String" jdbcType="varchar2" property="repyear"/>
        <parameter javaType="String" jdbcType="varchar2" property="repmonth"/>
    </parameterMap>
    <resultMap class="commonj.sdo.DataObject" id="resultMap">
        <result column="forcastwelldata" javaType="Double" property="forcastwelldata"/>
    </resultMap>
    <select id="forcastwelldata" parameterMap="parameter" resultMap="resultMap">
select  sum(t.wellsnumberf) as forcastwelldata from jtc_projectprocess t 
<isNotNull property="branch">
where t.branch=#branch#  
</isNotNull>
<isNotNull  prepend="AND" property="repyear">
t.repyear=#repyear#
</isNotNull>
<isNotNull  prepend="AND" property="repmonth">
t.repmonth=#repmonth# group by t.repmonth
</isNotNull> </select>
</sqlMap>

Answer 1

sum(t.wellsnumberf) as forcastwelldata  这是你查询出来的列名然而，你在 Map 中定义了三个属性，却不包含 forcastwelldata   增加一行         <parameter javaType="String" jdbcType="varchar2" property="forcastwelldata"/>

Answer 2

加上那行代码了，还是不行，同样的错Caused by: com.primeton.das.sql.impl.ibatis.sqlmap.client.SqlMapException: There is no statement named com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata in this SqlMap.
at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:308)
at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:625)
at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:608)
at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.primeton.das.sql.impl.NamedSqlSessionImpl.queryForList(NamedSqlSessionImpl.java:150)
at com.primeton.spring.support.DatabaseExt.queryByNamedSql(DatabaseExt.java:863)
at com.eos.spring.DASTemplate.queryByNamedSql(DASTemplate.java:458)
at com.primeton.eos.JtcProjectprocessService.forcastwell(JtcProjectprocessService.java:37)
at com.primeton.eos.JtcProjectprocessService$$FastClassByCGLIB$$bd67f9b8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.primeton.spring.interceptor.BeanInterceptor.invoke(BeanInterceptor.java:114)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.primeton.eos.JtcProjectprocessService$$EnhancerByCGLIB$$cfb25867.forcastwell(<generated>)
at com.primeton.eos.JtcProjectprocessService$$FastClassByCGLIB$$bd67f9b8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.primeton.eos.JtcProjectprocessService$$EnhancerByCGLIB$$85062995.forcastwell(<generated>)
at com.primeton.eos.JtcProjectprocessService$$FastClassByCGLIB$$bd67f9b8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.primeton.spring.interceptor.BeanInterceptor.invoke(BeanInterceptor.java:114)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.primeton.eos.JtcProjectprocessService$$EnhancerByCGLIB$$5b479237.forcastwell(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.primeton.spring.invoker.SpringInvoker.invoke(SpringInvoker.java:56)
at com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata_biz.invokeSpring0(forcastwelldata_biz.java:222)
at com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata_biz.__choiceinvokeSpring0(forcastwelldata_biz.java:528)
at com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata_biz.__invokeBiz(forcastwelldata_biz.java:473)
at com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata_biz._invoke(forcastwelldata_biz.java:386)
at com.primeton.eos.forcastwell.impl.forcastwell.forcastwelldata_biz.invoke(forcastwelldata_biz.java:422)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:170)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:52)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:48)
at $Proxy25.invoke(Unknown Source)
at com.primeton.ext.engine.component.LogicflowInvokerHelper.invokeLogicflow(LogicflowInvokerHelper.java:62)
... 36 more

Answer 3

<sqlMap>
    <parameterMap class="commonj.sdo.DataObject" id="parameterMap">
        <parameter javaType="String" jdbcType="varchar2" property="branch"/>
        <parameter javaType="String" jdbcType="varchar2" property="repyear"/>
        <parameter javaType="String" jdbcType="varchar2" property="repmonth"/>
        <parameter javaType="String" jdbcType="varchar2" property="forcastwelldata"/>
    </parameterMap>
    <resultMap class="commonj.sdo.DataObject" id="resultMap">
        <result column="forcastwelldata" javaType="Double" property="forcastwelldata"/>
    </resultMap>
    <select id="forcastwelldata" parameterMap="parameterMap" resultMap="resultMap">
    select  sum(t.wellsnumberf) as forcastwelldata from jtc_projectprocess t 
    <isNotNull property="branch">
        where t.branch=#branch#  
    </isNotNull>   
    <isNotNull  prepend="AND" property="repyear">
        t.repyear=#repyear#
    </isNotNull>
    <isNotNull  prepend="AND" property="repmonth">
        t.repmonth=#repmonth# group by t.repmonth
    </isNotNull>
 
    </select>
</sqlMap>