update报错

zhangql8

String ksql ="UPDATE LA_SAMPLE S SET S.fSAMPLEQUALITY='"+fSAMPLEQUALITY+"'  WHERE S.fID='"+LA_SAMPLE+"' OR S.fPEARENTID='"+LA_SAMPLE+"'";                                                                                       
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE LA_SAMPLE S SET S.fSAMPLEQUALITY='不合格'  WHERE S.fID='BDEBA622705A4EC8A43EFBB2149BA6D2' OR S.fPEARENTID='BDEBA622705A4EC8A43EFBB2149BA6D2'        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.KSQL.executeUpdate(Unknown Source)        at Sample.updateSampleQuality(Sample.java:715)        ... 30 moreCaused by: com.justep.exception.BusinessException: 编码: JUSTEP154038; 提示: S.fID找不到对应的关系映射        at com.justep.exception.BusinessException.create(Unknown Source)        at com.justep.util.Utils.check(Unknown Source)        at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)        ... 36 more               

jishuang

S.fID改为S

zhangql8

jishuang 发表于 2019-8-26 10:53
S.fID改为S

请关闭