|
楼主 |
发表于 2017-8-10 11:00:18
|
显示全部楼层
本帖最后由 1138127608 于 2017-8-10 11:03 编辑
- newTable:true keepData:false backTable:false existsTable:true hasData:false
- 删除原表,创建新表
- SQLInvoker.execute:DROP TABLE DEMO_Attachment
- SQLInvoker.execute:CREATE TABLE DEMO_Attachment(fID VARCHAR(100),version INT COMMENT '版本',fSampleName VARCHAR(128) COMMENT '示例名称',fAttachment LONGTEXT COMMENT '附件',fTitle VARCHAR(128) COMMENT '标题',fNumber VARCHAR(32) COMMENT '编号',fAuthor VARCHAR(32) COMMENT '作者',fCreateDate DATE COMMENT '成文日期',fBlobImage LONGBLOB COMMENT 'BlobImage', PRIMARY KEY(fID))
- 耗时:5186
- 2017-08-10 10:59:10 加载模块:/demo/common/data/init ...
- 2017-08-10 10:59:10 excute stream action, params:{"accept":"application/json","action":"initOADBAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","process":"/OA/personalOffice/process/initOADB/initOADBProcess"}
- java.lang.reflect.InvocationTargetException
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:497)
- at com.justep.system.action.Engine.invokeActions(Native Method)
- at com.justep.system.action.Engine.invokeActions(Unknown Source)
- at com.justep.business.server.BusinessServer.doAction(Unknown Source)
- at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
- at com.justep.business.server.BusinessServer.excute(Unknown Source)
- at com.justep.business.server.BusinessServer.excute(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
- at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
- at org.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)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
- at java.lang.Thread.run(Thread.java:745)
- Caused by: java.lang.reflect.InvocationTargetException
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:497)
- at com.justep.system.action.Engine.invokeAction(Native Method)
- at com.justep.system.action.Engine.invokeAction(Unknown Source)
- at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
- at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
- at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
- at InitOA.initOADB(InitOA.java:23)
- ... 27 more
- Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154166; 提示: 执行KSQL文件"E:\BeX5_V3.6_1hls\model\BIZ\demo\common\data\init\z_export.data.ksql"出错
- at com.justep.exception.BusinessException.create(Unknown Source)
- at com.justep.util.InitUtils.executeKsqlFile(Unknown Source)
- at com.justep.util.InitUtils.initModelDbByKsql(Unknown Source)
- at com.justep.util.InitUtils.initDb(Unknown Source)
- at com.justep.util.InitUtils.initAppDb(Unknown Source)
- at Init.executeInitSQL(Init.java:47)
- at Init.initDemoDB(Init.java:19)
- ... 37 more
- Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: insert into DEMO_Customers DEMO_Customers (DEMO_Customers,DEMO_Customers.version,DEMO_Customers.fCompanyName,DEMO_Customers.fContactName,DEMO_Customers.fContactTitle,DEMO_Customers.fAddress,DEMO_Customers.fCity,DEMO_Customers.fRegion,DEMO_Customers.fPostalCode,DEMO_Customers.fCountry,DEMO_Customers.fPhone,DEMO_Customers.fFax) values ('07FFEB7712E6405797DD56714EF7331B',0,'立日股份有限公司','李柏麟','物主','惠安大路 38 号','石家庄','华北','502299','中国','(031) 4234226','(031) 4234227')
- at com.justep.exception.BusinessException.create(Unknown Source)
- 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.KSQL.executeUpdate(Unknown Source)
- at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
- ... 43 more
- Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO DEMO_Customers (DEMO_Customers.fCustomerID, DEMO_Customers.VERSION, DEMO_Customers.FCOMPANYNAME, DEMO_Customers.FCONTACTNAME, DEMO_Customers.FCONTACTTITLE, DEMO_Customers.FADDRESS, DEMO_Customers.FCITY, DEMO_Customers.FREGION, DEMO_Customers.FPOSTALCODE, DEMO_Customers.FCOUNTRY, DEMO_Customers.FPHONE, DEMO_Customers.FFAX) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), binds: [07FFEB7712E6405797DD56714EF7331B, 0, 立日股份有限公司, 李柏麟, 物主, 惠安大路 38 号, 石家庄, 华北, 502299, 中国, (031) 4234226, (031) 4234227]出错
- at com.justep.exception.BusinessException.create(Unknown Source)
- at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
- ... 48 more
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '????????' for key 'IDX_2089947656'
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
- at com.mysql.jdbc.Util.getInstance(Util.java:383)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
- at com.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)
- at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
- at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
- ... 49 more
复制代码 eclipse报错信息 |
|