ORA-00001: 违反唯一约束条件

gost_1223

说明：OA_AS_InD 属于从表数据，数据源添加数据（包含fID）后点击保存，问什么sql 语句的参数总是从version 开始
报错内容：
Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO OA_AS_InD OA_AS_InD(OA_AS_InD, OA_AS_InD.version, OA_AS_InD.fKind, OA_AS_InD.fCode, OA_AS_InD.fName, OA_AS_InD.fSpecType, OA_AS_InD.fUnit, OA_AS_InD.foffNum, OA_AS_InD.fAmount, OA_AS_InD.fDate, OA_AS_InD.fIsInName, OA_AS_InD.fIsCheckName, OA_AS_InD.fBuyApplyID, OA_AS_InD.fBuyApplyNO, OA_AS_InD.fBuyDetailID, OA_AS_InD.fCheckNO, OA_AS_InD.fServicTag, OA_AS_InD.fESCode, OA_AS_InD.fSHKSSJ, OA_AS_InD.fSHJSSJ, OA_AS_InD.fRemark, OA_AS_InD.fKindID, OA_AS_InD.fUnitID, OA_AS_InD.fMasterID, OA_AS_InD.fIsCheck, OA_AS_InD.fCheckID, OA_AS_InD.fIsIn, OA_AS_InD.fChecked) VALUES (:OA_AS_InD, :version, :fKind, :fCode, :fName, :fSpecType, :fUnit, :foffNum, :fAmount, :fDate, :fIsInName, :fIsCheckName, :fBuyApplyID, :fBuyApplyNO, :fBuyDetailID, :fCheckNO, :fServicTag, :fESCode, :fSHKSSJ, :fSHJSSJ, :fRemark, :fKindID, :fUnitID, :fMasterID, :fIsCheck, :fCheckID, :fIsIn, :fChecked)时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(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.impl.TableImpl.insert(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)
        ... 25 more
Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO OA_AS_InD (OA_AS_InD.fID, OA_AS_InD.VERSION, OA_AS_InD.FKIND, OA_AS_InD.FCODE, OA_AS_InD.FNAME, OA_AS_InD.FSPECTYPE, OA_AS_InD.FUNIT, OA_AS_InD.FOFFNUM, OA_AS_InD.FAMOUNT, OA_AS_InD.FDATE, OA_AS_InD.FISINNAME, OA_AS_InD.FISCHECKNAME, OA_AS_InD.FBUYAPPLYID, OA_AS_InD.FBUYAPPLYNO, OA_AS_InD.FBUYDETAILID, OA_AS_InD.FCHECKNO, OA_AS_InD.FSERVICTAG, OA_AS_InD.FESCODE, OA_AS_InD.FSHKSSJ, OA_AS_InD.FSHJSSJ, OA_AS_InD.FREMARK, OA_AS_InD.FKINDID, OA_AS_InD.FUNITID, OA_AS_InD.FMASTERID, OA_AS_InD.FISCHECK, OA_AS_InD.FCHECKID, OA_AS_InD.FISIN, OA_AS_InD.FCHECKED) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[1, 0, 扩展柜, null, 山寨扩展柜, 山寨, 张, null, 2000, null, 未入库, 未验收, A41F84374F4B49A292F4B218D59A46B8, GZCGD201311060010, 772DED8543874345AB7A53E5B0E74E53, null, 固定资产, null, null, null, null, 45E470B9E0AE4FAAA354874067F55D8F, 0E1C524EB3F14A7B8C7CCAFDB44CFB83, 1D6B59E5C45A4A4886E05EFFDA860AF1, 0, null, 0, null]出错！
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 33 more
Caused by: java.sql.SQLException: ORA-00001: 违反唯一约束条件 (JUSTEP_OA.SYS_C0017996)

zhaixin

fid是数据表中的主键吗，主键的值是如何生成的？

gost_1223

在java中用CommonUtils.createGUID() 方法生成放入Table 的fID 的列中，但前台调试时data.getCurrentID() 获取的值是1、2、3 。 保存时就报违反唯一约束的错误

gost_1223

因为保存一直报错，我就换了一种方法，将table 传会前台，遍历 该table的rows，遍历时 进行newData()，然后把table中各列的值填入，现在已经避过了这个错误

gost_1223

在java 后台创建table 然后向table中赋值，然后把该table传到前台，放入grid，在这个操作中如何把table主键也存入grid