关于在流程事件里编写java更新其他表单字段内容的问题。

metatron

我的代码，为了方便把原来的代码注释掉作参考了、
public static void businessActivity4AfterAdvance() {
       
               
                //  try {
               //         String key = com.justep.system.process.ProcessUtils.getProcessData1();
                        // 定义更新ksql，由于概念没有主键关系，所以使用概念别名作为概念的主键
               //        String kSql = "update X5_CostRequest a set a.fState='已审批' where a='" + key + "'";
               //         KSQL.executeUpdate(kSql,null,"/x5demo/bizDemo/data",null);
              //  }
              //  catch (Exception e) {
              //          throw new RuntimeException (e.getMessage());
              //  }               
        
      
            try {
                     
                  String key = com.justep.system.process.ProcessUtils.getProcessData1();
                  // 定义更新ksql，由于概念没有主键关系，所以使用概念别名作为概念的主键
                  String kSql = "update HU_CarInfo set HU_CarInfo.CarStatus='已预约' where HU_CarUsing='" + key + "'";
                  KSQL.executeUpdate(kSql,null,"/huanan/Safety/data",null);
          }
          catch (Exception e) {
                  throw new RuntimeException (e.getMessage());
          }               
  

metatron

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)
        at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)
        ... 30 more
Caused by: java.lang.RuntimeException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update HU_CarInfo set HU_CarInfo.CarStatus='已预约' where HU_CarUsing='C7CD3C1A7DC44904BE7E2A8AC9F7DFC4'
        at CarUsingProcess.businessActivity4AfterAdvance(CarUsingProcess.java:37)
        ... 41 more

jishuang

ksql中概念必须区别名

metatron

好的我去试试

metatron

已经解决了，请结贴