保存一条正常,保存多条报错

qq444862527

新建数据,保存一条时正常,保存多条时,就报错了,数据类型是simpleCaused by: java.sql.SQLException: ORA-00001: 违反唯一约束条件 (X5SYS.SYS_C0028830)

2014-10-15 15:17:11 action result:{"code":"JUSTEP150210","reason":"无","data":"","message":"执行KSQL出错, KSQL: INSERT INTO TAW_AFFILIATEID_CUST TAW_AFFILIATEID_CUST(TAW_AFFILIATEID_CUST, TAW_AFFILIATEID_CUST.version, TAW_AFFILIATEID_CUST.affilatedid, TAW_AFFILIATEID_CUST.DEVICE_NAME, TAW_AFFILIATEID_CUST.FOREIGN_ATTR_VALUE, TAW_AFFILIATEID_CUST.NODE_ID) VALUES (:TAW_AFFILIATEID_CUST, :version, :affilatedid, EVICE_NAME, :FOREIGN_ATTR_VALUE, :NODE_ID)","flag":false,"stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:592)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:595)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO TAW_AFFILIATEID_CUST TAW_AFFILIATEID_CUST(TAW_AFFILIATEID_CUST, TAW_AFFILIATEID_CUST.version, TAW_AFFILIATEID_CUST.affilatedid, TAW_AFFILIATEID_CUST.DEVICE_NAME, TAW_AFFILIATEID_CUST.FOREIGN_ATTR_VALUE, TAW_AFFILIATEID_CUST.NODE_ID) VALUES (:TAW_AFFILIATEID_CUST, :version, :affilatedid, EVICE_NAME, :FOREIGN_ATTR_VALUE, :NODE_ID); 可能的原因: 无\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.insert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.BizData.save(Unknown Source)\r\n\tat BizProcedure.save(BizProcedure.java:18)\r\n\t... 26 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO TAW_AFFILIATEID_CUST (TAW_AFFILIATEID_CUST.fID, TAW_AFFILIATEID_CUST.VERSION, TAW_AFFILIATEID_CUST.AFFILATEDID, TAW_AFFILIATEID_CUST.DEVICE_NAME, TAW_AFFILIATEID_CUST.FOREIGN_ATTR_VALUE, TAW_AFFILIATEID_CUST.NODE_ID) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [EC5A39D457B441DE8399FBDCBAD6FF0F, 0, 81F70B74D30A463092F12619C83CCAF5, , EBFD6B8230E93048E0438500FEC83048, 1211512106067]出错; 可能的原因: 无\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)\r\n\t... 35 more\r\nCaused by: java.sql.SQLException: ORA-00001: 违反唯一约束条件 (X5SYS.SYS_C0028830)\n\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)\r\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)\r\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\t... 36 more\r\n","messages":"[\"编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO TAW_AFFILIATEID_CUST TAW_AFFILIATEID_CUST(TAW_AFFILIATEID_CUST, TAW_AFFILIATEID_CUST.version, TAW_AFFILIATEID_CUST.affilatedid, TAW_AFFILIATEID_CUST.DEVICE_NAME, TAW_AFFILIATEID_CUST.FOREIGN_ATTR_VALUE, TAW_AFFILIATEID_CUST.NODE_ID) VALUES (:TAW_AFFILIATEID_CUST, :version, :affilatedid, EVICE_NAME, :FOREIGN_ATTR_VALUE, :NODE_ID); 可能的原因: 无\",\"编码: JUSTEP150039; 提示: 执行sql: INSERT INTO TAW_AFFILIATEID_CUST (TAW_AFFILIATEID_CUST.fID, TAW_AFFILIATEID_CUST.VERSION, TAW_AFFILIATEID_CUST.AFFILATEDID, TAW_AFFILIATEID_CUST.DEVICE_NAME, TAW_AFFILIATEID_CUST.FOREIGN_ATTR_VALUE, TAW_AFFILIATEID_CUST.NODE_ID) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [EC5A39D457B441DE8399FBDCBAD6FF0F, 0, 81F70B74D30A463092F12619C83CCAF5, , EBFD6B8230E93048E0438500FEC83048, 1211512106067]出错; 可能的原因: 无\",\"ORA-00001: 违反唯一约束条件 (X5SYS.SYS_C0028830)\\n\"]"}

qq444862527

搞错了,结贴吧