報錯內容就是說我寫的命名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>
uj5u.com熱心網友回復：
請大神幫忙看看哪里出錯了
謝謝各位了！！
uj5u.com熱心網友回復：
sum(t.wellsnumberf) as forcastwelldata 這是你查詢出來的列名然而，你在 Map 中定義了三個屬性，卻不包含 forcastwelldata
增加一行
<parameter javaType="String" jdbcType="varchar2" property="forcastwelldata"/>
uj5u.com熱心網友回復：
加上那行代碼了，還是不行，同樣的錯。。。
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
uj5u.com熱心網友回復：
請問問題解決了嗎 我也遇到同樣的問題uj5u.com熱心網友回復：
<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>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90756.html
標籤：開發
上一篇：oracle如何在千萬條記錄的表中快速高效查詢最近的1000條記錄
下一篇：Orcale的DMP檔案匯入問題