开发程序时将数据保存到bizdata，系统报错如下，请问是哪里出了问题？
保存数据失败！
执行KSQL出错, KSQL: INSERTINTO ComponentQTResults ComponentQTResults(ComponentQTResults,ComponentQTResults.version, ComponentQTResults.fClientName1,ComponentQTResults.fComponentClassificationQT,ComponentQTResults.fComponentNumberQT,ComponentQTResults.fComponentSizePictureFilePath,ComponentQTResults.fComponentSizeQTResults,ComponentQTResults.fComponentTypeQT,ComponentQTResults.fConcealedWorkPictureFilePath,ComponentQTResults.fConcealedWorkQTResults,ComponentQTResults.fDeliveryBatchNumberQT, ComponentQTResults.fDeliveryDate,ComponentQTResults.fMouldSizePictureFilePath,ComponentQTResults.fMouldSizeQTResults, ComponentQTResults.fOrderNumberQT,ComponentQTResults.fProductionDate) VALUES (:ComponentQTResults, :version,:fClientName1, :fComponentClassificationQT, :fComponentNumberQT,:fComponentSizePictureFilePath, :fComponentSizeQTResults, :fComponentTypeQT,:fConcealedWorkPictureFilePath, :fConcealedWorkQTResults,:fDeliveryBatchNumberQT, :fDeliveryDate, :fMouldSizePictureFilePath,:fMouldSizeQTResults, :fOrderNumberQT, :fProductionDate) 编码：JUSTEP150210 隐藏详细 java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606) atcom.justep.system.action.Engine.invokeActions(Native Method) atcom.justep.system.action.Engine.invokeActions(Unknown Source) atcom.justep.business.server.BusinessServer.doAction(Unknown Source) atcom.justep.business.server.BusinessServer.doExcute(Unknown Source) atcom.justep.business.server.BusinessServer.excute(Unknown Source) atcom.justep.business.server.BusinessServer.excute(Unknown Source) atcom.justep.business.server.BusinessServerServlet.execService(Unknown Source) atcom.justep.business.server.BusinessServerServlet.service(Unknown Source) atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723) atcom.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) atjava.lang.Thread.run(Thread.java:745) Caused by:com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO ComponentQTResultsComponentQTResults(ComponentQTResults, ComponentQTResults.version,ComponentQTResults.fClientName1, ComponentQTResults.fComponentClassificationQT,ComponentQTResults.fComponentNumberQT,ComponentQTResults.fComponentSizePictureFilePath,ComponentQTResults.fComponentSizeQTResults,ComponentQTResults.fComponentTypeQT,ComponentQTResults.fConcealedWorkPictureFilePath, ComponentQTResults.fConcealedWorkQTResults,ComponentQTResults.fDeliveryBatchNumberQT, ComponentQTResults.fDeliveryDate,ComponentQTResults.fMouldSizePictureFilePath,ComponentQTResults.fMouldSizeQTResults, ComponentQTResults.fOrderNumberQT,ComponentQTResults.fProductionDate) VALUES (:ComponentQTResults, :version,:fClientName1, :fComponentClassificationQT, :fComponentNumberQT,:fComponentSizePictureFilePath, :fComponentSizeQTResults, :fComponentTypeQT,:fConcealedWorkPictureFilePath, :fConcealedWorkQTResults, :fDeliveryBatchNumberQT,:fDeliveryDate, :fMouldSizePictureFilePath, :fMouldSizeQTResults,:fOrderNumberQT, :fProductionDate) atcom.justep.exception.BusinessException.create(Unknown Source) atcom.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source) atcom.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(UnknownSource) at com.justep.system.data.KSQL.executeUpdate(Unknown Source) atcom.justep.system.data.KSQL.executeUpdate(Unknown Source) atcom.justep.system.data.impl.TableImpl.insert(Unknown Source) atcom.justep.system.data.impl.TableImpl.save(Unknown Source) atcom.justep.system.data.impl.TableImpl.save(Unknown Source) atcom.justep.system.data.BizData.save(Unknown Source) atBizProcedure.save(BizProcedure.java:18) ... 27 more Caused by:com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTOCOMPONENTQTRESULTS (COMPONENTQTRESULTS.fID, COMPONENTQTRESULTS.VERSION,COMPONENTQTRESULTS.FCLIENTNAME1, COMPONENTQTRESULTS.FCOMPONENTCLASSIFICATIONQT,COMPONENTQTRESULTS.FCOMPONENTNUMBERQT,COMPONENTQTRESULTS.FCOMPONENTSIZEPICTUREFILEPATH,COMPONENTQTRESULTS.FCOMPONENTSIZEQTRESULTS,COMPONENTQTRESULTS.FCOMPONENTTYPEQT,COMPONENTQTRESULTS.FCONCEALEDWORKPICTUREFILEPATH,COMPONENTQTRESULTS.FCONCEALEDWORKQTRESULTS, COMPONENTQTRESULTS.FDELIVERYBATCHNUMBERQT,COMPONENTQTRESULTS.FDELIVERYDATE, COMPONENTQTRESULTS.FMOULDSIZEPICTUREFILEPATH,COMPONENTQTRESULTS.FMOULDSIZEQTRESULTS, COMPONENTQTRESULTS.FORDERNUMBERQT,COMPONENTQTRESULTS.FPRODUCTIONDATE) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ?, ? , ? , ? , ? , ? , ? , ? ), binds: [35CD54077D9343CBB67EE99608FA7A56, 0,null, null, 35%37%40%0, null, null, 40, null, null, 37, null, null, null, 35,null]出错 atcom.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.ksql.KSQLUtils.execSqlUpdate(UnknownSource) ... 36 more Caused by:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException  uplicate entry '35CD54077D9343CBB67EE99608FA7A56' for key 'PRIMARY' atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:400) atcom.mysql.jdbc.Util.getInstance(Util.java:383) atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) atcom.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) atcom.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) atcom.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) atcom.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) atcom.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: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)atorg.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)... 37 more
|
IP卡
狗仔卡
发表于 2016-8-11 10:11:46
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2016-8-11 10:43:07
楼主
