走向秃头的觉
2020-12-10 18:45
采纳率: 40%
浏览 130
已采纳

Cause: java.sql.SQLException: ORA-01013

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred while applying a parameter map.  
--- Check the updateEcUserfacctfreezzlogByPK-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: ORA-01013: 用户请求取消当前的操作

        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.java:67)
        at com.commsoft.sys.dbcommon.dao.EcUserfacctfreezzlogDAO.updateEcUserfacctfreezzlogByPK(EcUserfacctfreezzlogDAO.java:62)
        at com.commsoft.sys.useraccount.service.UserAccountService.updateCardChange(UserAccountService.java:1336)
        at com.commsoft.sys.useraccount.service.UserAccountService$$FastClassByCGLIB$$e570be4.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
        at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
        at com.commsoft.sys.useraccount.service.UserAccountService$$EnhancerByCGLIB$$bdabe772.updateCardChange(<generated>)
        at com.commsoft.sys.useraccount.struts.action.UserAccountAction.cardChange(UserAccountAction.java:1073)
        at sun.reflect.GeneratedMethodAccessor1736.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:892)
        at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1294)
        at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
        at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
        at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
        at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1370)
        at ognl.ASTMethod.getValueBody(ASTMethod.java:91)
        at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
        at ognl.SimpleNode.getValue(SimpleNode.java:258)
        at ognl.Ognl.getValue(Ognl.java:467)
        at ognl.Ognl.getValue(Ognl.java:431)
        at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:352)
        at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:404)
        at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:350)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251)
        at org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
        at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
        at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
        at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
        at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
        at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
:

项目框架是spring ,数据库是oracle , sql语句在下面,事务是spring管理的.想知道这个bug是什么情况下产生的.

 

update ec_userfacctfreezzlog set id = #id#
        <dynamic>
            <isNotNull prepend="," property="cardcode">
                cardcode = #cardcode#
            </isNotNull>
            <isNotNull prepend="," property="cardsn">
                cardsn = #cardsn#
            </isNotNull>
            <isNotNull prepend="," property="money">
                money = #money#
            </isNotNull>
            <isNotNull prepend="," property="state">
                state = #state#
            </isNotNull>
            <isNotNull prepend="," property="remark">
                remark = #remark#
            </isNotNull>
            <isNotNull prepend="," property="blackstate">
                blackstate = #blackstate#
            </isNotNull>
            <isNotNull prepend="," property="blacktime">
                blacktime = #blacktime#
            </isNotNull>
            <isNotNull prepend="," property="remark1">
                remark1 = #remark1#
            </isNotNull>
            <isNotNull prepend="," property="datastate">
                datastate = #datastate#
            </isNotNull>
            <isNotNull prepend="," property="datatime">
                datatime = #datatime#
            </isNotNull>
            <isNotNull prepend="," property="remark2">
                remark2 = #remark2#
            </isNotNull>
            <isNotNull prepend="," property="balanstate">
                balanstate = #balanstate#
            </isNotNull>
            <isNotNull prepend="," property="balantime">
                balantime = #balantime#
            </isNotNull>
            <isNotNull prepend="," property="remark3">
                remark3 = #remark3#
            </isNotNull>
        </dynamic>
        where id = #id#
    </update>
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

16条回答 默认 最新