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

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条回答 默认 最新

  • sinJack 2020-12-11 10:34
    关注

    bug什么原因导致的,给你解释了。没啥问题,采纳一下吧

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(15条)

报告相同问题?

悬赏问题

  • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
  • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
  • ¥15 win10,这种情况怎么办
  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥15 Matlab求解微分方程,如何用fish2d进行预优?