组织机构同步问题

adjust

jishuang 发表于 2019-9-10 17:17
跟踪调试游戏平台默认的功能会去传参的

通过以下代码：

1. //循环table，处理人员变动
   
2.                             Iterator it = table.iterator();
   
3.                             while (it.hasNext()){
   
4.                                     Row r = (Row) it.next();
   
5.                                     System.out.println(r.getValue("sID").toString());
   
6.                                     System.out.println(r.getString("sParent").toString());
   
7.                                     //处理人员变动的信息
   
8.                                     OrgHelper.moveOrg(r.getValue("sID").toString(), null, r.getString("sParent").toString());
   
9.                             }

复制代码

提示如下错误：

1. com.justep.exception.BusinessException: 编码: JUSTEP150129; 提示: 事务提交失败
   
2.         at com.justep.exception.BusinessException.create(Unknown Source)
   
3.         at com.justep.system.action.Engine.transactionCommit(Unknown Source)
   
4.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
5.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
6.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
7.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
8.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
9.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
   
10.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
11.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
12.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
13.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
14.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
15.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
16.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
17.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
18.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
19.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
20.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
21.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
22.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
23.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
24.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
25.         at java.lang.Thread.run(Thread.java:745)
    
26. Caused by: java.sql.SQLException: commit() should not be called while in auto-commit mode.
    
27.         at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)
    
28.         at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
    
29.         at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
    
30.         at com.justep.system.data.Transaction.commit(Unknown Source)
    
31.         ... 23 more

复制代码

jishuang

不能在循环中删除，把要删除的存到一个变量中，在循环外删除

adjust

jishuang 发表于 2019-9-11 17:24
不能在循环中删除，把要删除的存到一个变量中，在循环外删除

如果不循环执行，如何批量处理？这里的moveOrg是用来修改人员变动部门，只能根据一个个执行

jishuang

把要删除的存到一个变量中，在循环外删除

adjust

jishuang 发表于 2019-9-12 08:50
把要删除的存到一个变量中，在循环外删除

答非所问。。。找到原因了，moveOrg是每次都要开启一个链接然后关闭，我获取table内容后没有主动把链接关闭，造成的commit() 错误。

  

结题