ksql insert 子查询 怎么批量产生主键

honghulong

KSQL.executeUpdate("insert into XS_KC a (a,a.fCPID, a.fCPMC,a.fSL) (select :guid(), b.fCPID,b.fCPMC,b.fCPSL from XS_CGLCZHIBIAO b where b.fMASTERID =:fMASTERID)",params,"/XSGLXT/productManager/data",null);


Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO XS_KC(XS_KC.fID, XS_KC.FCPID, XS_KC.FCPMC, XS_KC.FSL)(SELECT   ? , b.fCPID AS fCPID, b.fCPMC AS fCPMC, b.fCPSL AS fCPSL FROM XS_CGLCZHIBIAO b  WHERE b.fMASTERID =  ? ), binds: [39ABAC3F345A4C9A9C83C440FBAA185E, 7E11249D342F4959B8380240DAA2FDF2]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 55 more
Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__XS_KC__D9F8259C6774552F'. Cannot insert duplicate key in object 'dbo.XS_KC'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 56 more

jishuang

直接用guid()就可以

honghulong

果然搞定了 ，我用错了 :guid()  ，不带冒号果然可以，谢谢