起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 3568|回复: 2

[结贴] 主从数据删除

[复制链接]

87

主题

250

帖子

650

积分

高级会员

Rank: 4

积分
650
QQ
发表于 2018-12-3 14:49:40 | 显示全部楼层 |阅读模式
做了个主从表;

删除从表数据的时候,总是报错。


请帮忙解答一下,有什么办法可以绕过。
目前代码都是标准生成的,怎么改也没有思路。


Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: DELETE FROM WPBasicDataWindResorce WPBasicDataWindResorce__1 W
HERE WPBasicDataWindResorce__1 IN (SELECT WPBasicDataWindResorce__2 FROM WPBasic
DataWindResorce WPBasicDataWindResorce__2 WHERE WPBasicDataWindResorce__2.fFJPri
ceIdx IN (ldKey))
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlDelete(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unk
nown 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:18)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执
行sql: DELETE FROM WPBASICDATAWINDRESORCE  WHERE WPBASICDATAWINDRESORCE.fID IN (
SELECT  WPBasicDataWindResorce__2.fID FROM (WPBASICDATAWINDRESORCE WPBasicDataWi
ndResorce__2 LEFT JOIN WPFJPrice WPFJPrice__1 ON WPBasicDataWindResorce__2.fID =
WPFJPrice__1.fPriceFJId  )  WHERE  WPFJPrice__1.fID IN ( ? ) ), binds: [57BE966
5E42F44FA90122989A85BF195]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 42 more
Caused by: java.sql.SQLException: You can't specify target table 'WPBASICDATAWIN
DRESORCE' for update in FROM clause
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1901)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2113)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2049)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2034)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:105)
        ... 43 more

2018-12-03 14:46:08 excute stream action, params:{"actions":[{"accept":"applicat
ion/json","action":"saveWPFJPriceAction","actionFlag":"__action_0__","activity":
"FJ","contentType":"json","executeContext":"","executor":"","parameters":{"table
":{"@type":"table","rows":[{"fFJAppliedProj":{"value":"苏宝顶风电场"},"fFJBuyDat
e":{"value":"2018-11-08"},"fFJContractorPrice":{"value":16},"fPriceFJId":{"value
":"29AAB420D7E6488DAC23B67566ED5B65"},"userdata":{"id":{"value":"3D27567E9E8C46C
0B2F2A84A0104487D"},"isModified":false,"recordState":"delete"},"version":{"value
":1}}],"userdata":{"idColumnDefine":"WPFJPrice","idColumnName":"WPFJPrice","idCo
lumnType":"String","model":"/project/WindPower/data","relationAlias":"fFJApplied
Proj,fFJBuyDate,fFJContractorPrice,fPriceFJId,version","relationTypes":"String,D
ate,Float,String,Integer","relations":"WPFJPrice.fFJAppliedProj,WPFJPrice.fFJBuy
Date,WPFJPrice.fFJContractorPrice,WPFJPrice.fPriceFJId,WPFJPrice.version","sys.c
ount":2,"sys.rowid":"WPFJPrice","updateMode":"whereVersion"}}},"process":"/proje
ct/WindPower/process/windResorce/windResorceProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.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 Sour
ce)
        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(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: DELETE FROM WPBasicDataWindResorce WPBasicDataWindResorce__1 W
HERE WPBasicDataWindResorce__1 IN (SELECT WPBasicDataWindResorce__2 FROM WPBasic
DataWindResorce WPBasicDataWindResorce__2 WHERE WPBasicDataWindResorce__2.fFJPri
ceIdx IN (ldKey))
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlDelete(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unk
nown 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:18)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执
行sql: DELETE FROM WPBASICDATAWINDRESORCE  WHERE WPBASICDATAWINDRESORCE.fID IN (
SELECT  WPBasicDataWindResorce__2.fID FROM (WPBASICDATAWINDRESORCE WPBasicDataWi
ndResorce__2 LEFT JOIN WPFJPrice WPFJPrice__1 ON WPBasicDataWindResorce__2.fID =
WPFJPrice__1.fPriceFJId  )  WHERE  WPFJPrice__1.fID IN ( ? ) ), binds: [3D27567
E9E8C46C0B2F2A84A0104487D]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 42 more
Caused by: java.sql.SQLException: You can't specify target table 'WPBASICDATAWIN
DRESORCE' for update in FROM clause
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1901)



91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35878
发表于 2018-12-3 15:20:16 | 显示全部楼层
https://www.whatled.com/post-1820.html

java.sql.SQLException: You can't specify target table 'WPBASICDATAWIN
DRESORCE' for update in FROM clause

这个错误就是mysql数据库的标准报错
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

87

主题

250

帖子

650

积分

高级会员

Rank: 4

积分
650
QQ
 楼主| 发表于 2018-12-3 19:26:26 | 显示全部楼层
jishuang 发表于 2018-12-3 15:20
https://www.whatled.com/post-1820.html

java.sql.SQLException: You can't specify target table 'WPBA ...

请结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-3-29 10:30 , Processed in 0.056453 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表