设置了级联删除，在保存数据的时候报错。

liliang026@163

我按照教材里面的步骤设置了级联删除，并且成功，可以级联删除。但出现如下错误:



我打开主从页面，删除了一条从表数据，点击保存。就弹出了如上错误信息。后台异常如下：

2013-10-13 10:36:40 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor132.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)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksqlELETE FROM WA_YLRKD WA_YLRKD__1 WHERE WA_YLRKD__1 IN (SELECT WA_YLRKD__2 FROM WA_YLRKD WA_YLRKD__2 WHERE WA_YLRKD__2.fRKDMXIDS IN (ldKey))时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlDelete(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.deleteNormalSub(Unknown Source)
at com.justep.system.data.impl.TableImpl.cascadeDelete(Unknown Source)
at com.justep.system.data.impl.TableImpl.cascadeDelete(Unknown Source)
at com.justep.system.data.impl.TableImpl.delete(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.model.exception.ModelException: 执行sql：DELETE FROM WA_YLRKD  WHERE WA_YLRKD.fID IN (SELECT  WA_YLRKD__2.fID FROM (WA_YLRKD WA_YLRKD__2 LEFT JOIN WA_YLRKDMX WA_YLRKDMX__1 ON WA_YLRKD__2.fID = WA_YLRKDMX__1.fRKDID  )  WHERE  WA_YLRKDMX__1.fID IN ( ? ) ), binds:[BC8A33F0DDD0448E97E9F277E3928686]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 37 more
Caused by: java.sql.SQLException: You can't specify target table 'WA_YLRKD' for update in FROM clause
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 38 more
2013-10-13 10:36:40 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<actions><action direct-execute="false" process="/warehouseManagement/rawMaterialStorage/process/YLRKGL/yLRKGLProcess" activity="mainActivity" action-flag="__action_3__" executor="" execute-context="" name="saveWA_YLRKDAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="model">/warehouseManagement/rawMaterialStorage/data</userdata><userdata name="id-column-name">WA_YLRKD</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">WA_YLRKD</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">WA_YLRKD.fRKDH,WA_YLRKD.fRKRQ,WA_YLRKD.fSHDW,WA_YLRKD.fSHRQ,WA_YLRKD.fSHR,WA_YLRKD.fSHHRQ,WA_YLRKD.fSHHR,WA_YLRKD.fBZ,EXPRESS,WA_YLRKD.version</userdata><userdata name="relation-types">String,Date,String,Date,String,Date,String,String,Object,Integer</userdata><userdata name="relation-alias">fRKDH,fRKRQ,fSHDW,fSHRQ,fSHR,fSHHRQ,fSHHR,fBZ,space-column,version</userdata><userdata name="sys.rowid">WA_YLRKD</userdata><userdata name="sys.count">2</userdata><userdata name="concept">WA_YLRKD</userdata><userdata name="concept-alias">WA_YLRKD</userdata><userdata name="update-mode">whereVersion</userdata></rows></xbiz:table></parameter></parameters></action><action direct-execute="false" process="/warehouseManagement/rawMaterialStorage/process/YLRKGL/yLRKGLProcess" activity="mainActivity" action-flag="__action_4__" executor="" execute-context="" name="saveWA_YLRKDMXAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="deletes">BC8A33F0DDD0448E97E9F277E3928686</userdata><userdata name="deletemasterkeys">D2D54B7C29334D2297EBF7C379B85CCC</userdata><userdata name="concept">WA_YLRKDMX</userdata><userdata name="relations">WA_YLRKDMX.fCPMC,WA_YLRKDMX.fCPLX,WA_YLRKDMX.fCPGG,WA_YLRKDMX.fCPTH,WA_YLRKDMX.fCPCZ,WA_YLRKDMX.fCPDZ,WA_YLRKDMX.fCPDJ,WA_YLRKDMX.fSL,WA_YLRKDMX.fZZ,WA_YLRKDMX.fZJ,WA_YLRKDMX.fCPDW,WA_YLRKDMX.fCPGYS,WA_YLRKDMX.fMP,WA_YLRKDMX.fBZ,WA_YLRKDMX.fRKDID,EXPRESS,WA_YLRKDMX.version,WA_YLRKDMX.fCPID,WA_YLRKDMX.fCFWZ</userdata><userdata name="model">/warehouseManagement/rawMaterialStorage/data</userdata><userdata name="concept-alias">WA_YLRKDMX</userdata><userdata name="id-column-name">WA_YLRKDMX</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">WA_YLRKDMX</userdata><userdata name="relation-alias">fCPMC,fCPLX,fCPGG,fCPTH,fCPCZ,fCPDZ,fCPDJ,fSL,fZZ,fZJ,fCPDW,fCPGYS,fMP,fBZ,fRKDID,space-column,version,fCPID,fCFWZ</userdata><userdata name="relation-types">String,String,String,String,String,Float,Decimal,Float,Float,Decimal,String,String,String,String,String,Object,Integer,String,String</userdata><userdata name="update-mode">whereVersion</userdata><row id="BC8A33F0DDD0448E97E9F277E3928686" original-id="BC8A33F0DDD0448E97E9F277E3928686" selected="1"><userdata name="recordState">delete</userdata><cell original-value="asdf" changed="1">asdf</cell><cell original-value="asdf" changed="1">asdf</cell><cell original-value="asdf" changed="1">asdf</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="8.0" changed="1">8.0</cell><cell original-value="5" changed="1">5</cell><cell original-value="1.0" changed="1">1.0</cell><cell original-value="8.0" changed="1">8.0</cell><cell original-value="5" changed="1">5</cell><cell original-value="%E5%8F%AA" changed="1">%E5%8F%AA</cell><cell original-value="%E5%85%B4%E9%80%9A%E9%92%A2%E7%AE%A1%E6%9C%89%E9%99%90%E5%85%AC%E5%8F%B8" changed="1">%E5%85%B4%E9%80%9A%E9%92%A2%E7%AE%A1%E6%9C%89%E9%99%90%E5%85%AC%E5%8F%B8</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="D2D54B7C29334D2297EBF7C379B85CCC" changed="1">D2D54B7C29334D2297EBF7C379B85CCC</cell><cell original-value="" changed="1"/><cell original-value="0">0</cell><cell changed="1" original-value="4594E0FBAA344C7589E155A7E1974CC8">4594E0FBAA344C7589E155A7E1974CC8</cell><cell changed="1" original-value=""/></row></rows></xbiz:table></parameter></parameters></action></actions>
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor132.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)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksqlELETE FROM WA_YLRKD WA_YLRKD__1 WHERE WA_YLRKD__1 IN (SELECT WA_YLRKD__2 FROM WA_YLRKD WA_YLRKD__2 WHERE WA_YLRKD__2.fRKDMXIDS IN (ldKey))时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlDelete(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.deleteNormalSub(Unknown Source)
at com.justep.system.data.impl.TableImpl.cascadeDelete(Unknown Source)
at com.justep.system.data.impl.TableImpl.cascadeDelete(Unknown Source)
at com.justep.system.data.impl.TableImpl.delete(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.model.exception.ModelException: 执行sql：DELETE FROM WA_YLRKD  WHERE WA_YLRKD.fID IN (SELECT  WA_YLRKD__2.fID FROM (WA_YLRKD WA_YLRKD__2 LEFT JOIN WA_YLRKDMX WA_YLRKDMX__1 ON WA_YLRKD__2.fID = WA_YLRKDMX__1.fRKDID  )  WHERE  WA_YLRKDMX__1.fID IN ( ? ) ), binds:[BC8A33F0DDD0448E97E9F277E3928686]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 37 more
Caused by: java.sql.SQLException: You can't specify target table 'WA_YLRKD' for update in FROM clause
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 38 more

jishuang

级联删除怎么设置的？把对应的ontology文件发一下看看，标准那个是主表那个是从表

liliang026@163

jishuang 发表于 2013-10-14 09:50
级联删除怎么设置的？把对应的ontology文件发一下看看，标准那个是主表那个是从表 ...

已经解决，谢谢