平台事务和触发器事务的提交

yangkaiyuan

  请教:业务是在审核的时候我会去更新表里的部分字段,但在表的某个字段我有写触发器（触发器去实现插入部分数据到另张表 是after update的触发器）我在界面的js上写的是:
var dMaster = justep.xbl('dataMaster');
        dMaster.setValue('fDJZT',1);
        var sss=justep.Context.getCurrentPersonCode();
        var ssd=justep.Context.getCurrentPersonName();
        var dt=justep.Date.toString(new Date(), justep.Date.STANDART_FORMAT);
        dMaster.setValue('fSHSJ',dt);
        dMaster.setValue('fSHCZYDM',sss);
        dMaster.setValue('fSHCZYMC',ssd);
        var f=dMaster.saveData();

结果是:报错  34 more\r\nCaused by: java.sql.SQLException: 事务在触发器中结束。批处理已中止。

我想是不是在触发器里commit之后导致平台的事务提交不了还是怎么了？

fpj

看JS看不出有什么问题，将你的TOMCAT中信息贴一下看看。

jishuang

这段js是在什么时机执行的?

yangkaiyuan

<actions><action content-type="application/json" accept="application/json, text/javascript, */*"><![CDATA[{"process":"/AssetManager/ManagerToAsset/process/storeasset/storeassetProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"PSN01","executeContext":"","action":"saveMaw_store_income_billAction","parameters":{"table":{"@type":"table","userdata":{"relationAlias":"fDJH,fRKFS,fRKFSMC,fLRCZYDM,fLRCZYMC,fRKJE,fDJZT,fSHCZYDM,fSHCZYMC,fSHSJ,fLRSJ,space-column,version,fKFDM,fKFMC,fJGDM,fJGMC","relationTypes":"String,String,String,String,String,Decimal,Integer,String,String,DateTime,DateTime,Object,Integer,String,String,String,String","idColumnType":"String","sys.rowid":"maw_store_income_bill","idColumnDefine":"maw_store_income_bill","idColumnName":"maw_store_income_bill","sys.count":10,"relations":"maw_store_income_bill.fDJH,maw_store_income_bill.fRKFS,maw_store_income_bill.fRKFSMC,maw_store_income_bill.fLRCZYDM,maw_store_income_bill.fLRCZYMC,maw_store_income_bill.fRKJE,maw_store_income_bill.fDJZT,maw_store_income_bill.fSHCZYDM,maw_store_income_bill.fSHCZYMC,maw_store_income_bill.fSHSJ,maw_store_income_bill.fLRSJ,EXPRESS,maw_store_income_bill.version,maw_store_income_bill.fKFDM,maw_store_income_bill.fKFMC,maw_store_income_bill.fJGDM,maw_store_income_bill.fJGMC","model":"/AssetManager/ManagerToAsset/data","updateMode":"whereAll","concept":"maw_store_income_bill","conceptAlias":"maw_store_income_bill","deletes":"","deleteversions":""},"rows":[{"userdata":{"id":{"value":"360C12782C5E4B59BFF74E63BA203030","originalValue":"360C12782C5E4B59BFF74E63BA203030","changed":""},"recordState":"edit","rowid-changed":""},"fDJH":{"value":"2014052300017","originalValue":"2014052300017","changed":"0"},"fRKFS":{"value":"1","originalValue":"1","changed":"0"},"fRKFSMC":{"value":"\n直销入库","originalValue":"\n直销入库","changed":"0"},"fLRCZYDM":{"value":"SYSTEM","originalValue":"SYSTEM","changed":"0"},"fLRCZYMC":{"value":"system","originalValue":"system","changed":"0"},"fRKJE":{"value":80000,"originalValue":80000,"changed":"0"},"fDJZT":{"value":1,"originalValue":0,"changed":"1"},"fSHCZYDM":{"value":"SYSTEM","originalValue":"","changed":"1"},"fSHCZYMC":{"value":"system","originalValue":"","changed":"1"},"fSHSJ":{"value":"2014-05-23T16:55:41.376Z","originalValue":"","changed":"1"},"fLRSJ":{"value":"2014-05-23T16:55:01.418Z","originalValue":"2014-05-23T16:55:01.418Z","changed":"0"},"space-column":{"value":"","originalValue":"","changed":"0"},"version":{"value":0,"originalValue":0,"changed":"0"},"fKFDM":{"value":"","originalValue":"","changed":"0"},"fKFMC":{"value":"","originalValue":"","changed":"0"},"fJGDM":{"value":"JUSTEP","originalValue":"JUSTEP","changed":"0"},"fJGMC":{"value":"起步软件","originalValue":"起步软件","changed":"0"}}]}},"translateParameter":null}]]></action></actions>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE maw_store_income_bill maw_store_income_bill SET maw_store_income_bill.fDJZT = :fDJZT_new, maw_store_income_bill.fSHCZYDM = :fSHCZYDM_new, maw_store_income_bill.fSHCZYMC = :fSHCZYMC_new, maw_store_income_bill.fSHSJ = :fSHSJ_new  WHERE maw_store_income_bill= :maw_store_income_bill_old AND maw_store_income_bill.fDJH = :fDJH_old AND maw_store_income_bill.fRKFS = :fRKFS_old AND maw_store_income_bill.fRKFSMC = :fRKFSMC_old AND maw_store_income_bill.fLRCZYDM = :fLRCZYDM_old AND maw_store_income_bill.fLRCZYMC = :fLRCZYMC_old AND maw_store_income_bill.fRKJE = :fRKJE_old AND maw_store_income_bill.fDJZT = :fDJZT_old AND (maw_store_income_bill.fSHCZYDM is null OR maw_store_income_bill.fSHCZYDM = '') AND (maw_store_income_bill.fSHCZYMC is null OR maw_store_income_bill.fSHCZYMC = '') AND maw_store_income_bill.fSHSJ is null  AND maw_store_income_bill.fLRSJ = :fLRSJ_old AND maw_store_income_bill.version = :version_old AND (maw_store_income_bill.fKFDM is null OR maw_store_income_bill.fKFDM = '') AND (maw_store_income_bill.fKFMC is null OR maw_store_income_bill.fKFMC = '') AND maw_store_income_bill.fJGDM = :fJGDM_old AND maw_store_income_bill.fJGMC = :fJGMC_old
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.impl.TableImpl.edit(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:23)
        ... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: UPDATE MAW_STORE_INCOME_BILL SET MAW_STORE_INCOME_BILL.FDJZT =  ? , MAW_STORE_INCOME_BILL.FSHCZYDM =  ? , MAW_STORE_INCOME_BILL.FSHCZYMC =  ? , MAW_STORE_INCOME_BILL.FSHSJ =  ?   WHERE  (MAW_STORE_INCOME_BILL.fID =  ? ) AND (MAW_STORE_INCOME_BILL.FDJH =  ? ) AND (MAW_STORE_INCOME_BILL.FRKFS =  ? ) AND (MAW_STORE_INCOME_BILL.FRKFSMC =  ? ) AND (MAW_STORE_INCOME_BILL.FLRCZYDM =  ? ) AND (MAW_STORE_INCOME_BILL.FLRCZYMC =  ? ) AND (MAW_STORE_INCOME_BILL.FRKJE =  ? ) AND (MAW_STORE_INCOME_BILL.FDJZT =  ? ) AND ( (MAW_STORE_INCOME_BILL.FSHCZYDM IS NULL) OR (MAW_STORE_INCOME_BILL.FSHCZYDM = ?) ) AND ( (MAW_STORE_INCOME_BILL.FSHCZYMC IS NULL) OR (MAW_STORE_INCOME_BILL.FSHCZYMC = ?) ) AND (MAW_STORE_INCOME_BILL.FSHSJ IS NULL) AND (MAW_STORE_INCOME_BILL.FLRSJ =  ? ) AND (MAW_STORE_INCOME_BILL.VERSION =  ? ) AND ( (MAW_STORE_INCOME_BILL.FKFDM IS NULL) OR (MAW_STORE_INCOME_BILL.FKFDM = ?) ) AND ( (MAW_STORE_INCOME_BILL.FKFMC IS NULL) OR (MAW_STORE_INCOME_BILL.FKFMC = ?) ) AND (MAW_STORE_INCOME_BILL.FJGDM =  ? ) AND (MAW_STORE_INCOME_BILL.FJGMC =  ? ) , binds: [1, SYSTEM, system, 2014-05-23 16:55:41.376, 360C12782C5E4B59BFF74E63BA203030, 2014052300017, 1,
直销入库, SYSTEM, system, 80000, 0, , , 2014-05-23 16:55:01.418, 0, , , JUSTEP, 起步软件]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 34 more
Caused by: java.sql.SQLException: 事务在触发器中结束。批处理已中止。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 35 more
tomcat里面的报错,  我是在点击按钮时触发的！

jishuang

直接把sql语句拿到数据库中执行正确吗？

yangkaiyuan

嗯  我看了下应该是我触发器事务提交的时候的问题。可以结贴了！谢谢！