起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 5069|回复: 2

[结贴] 原生保存出错

[复制链接]

20

主题

56

帖子

106

积分

初级会员

Rank: 2

积分
106
QQ
发表于 2017-11-16 13:59:59 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
13:55:17 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveGrid_poveryFamilyIncomeInfomationAction","actionFlag":"__action_0__","activity":"establishingCard","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"IncomeInfomation_ID":{"changed":"1"},"IncomeInfomation_averageincome":{"changed":"1","value":10.5},"IncomeInfomation_caichanincome":{"changed":"1"},"IncomeInfomation_ecologicalcompensation":{"changed":"1"},"IncomeInfomation_familyID":{"changed":"1","value":2050},"IncomeInfomation_familyplanningincome":{"changed":"1","value":"4"},"IncomeInfomation_fiveguarantees":{"changed":"1","value":"6"},"IncomeInfomation_lowsecurityincome":{"changed":"1","value":"5"},"IncomeInfomation_otherreturnincome":{"changed":"1"},"IncomeInfomation_pensioninsurance":{"changed":"1"},"IncomeInfomation_productionincome":{"changed":"1","value":"2"},"IncomeInfomation_salary":{"changed":"1","value":"1"},"IncomeInfomation_shengchengincome":{"changed":"1"},"IncomeInfomation_totalincome":{"changed":"1","value":21},"IncomeInfomation_transferincome":{"changed":"1","value":"3"},"fID":{"changed":"1"},"userdata":{"id":{"value":"2CD6DA0E420A4FA1AAEC902EF04106F7"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}}],"userdata":{"idColumnDefine":"grid_poveryFamilyIncomeInfomation","idColumnName":"grid_poveryFamilyIncomeInfomation","idColumnType":"String","model":"/grid/povertyPeople/data","relationAlias":"IncomeInfomation_ID,IncomeInfomation_averageincome,IncomeInfomation_caichanincome,IncomeInfomation_ecologicalcompensation,IncomeInfomation_familyID,IncomeInfomation_familyplanningincome,IncomeInfomation_fiveguarantees,IncomeInfomation_lowsecurityincome,IncomeInfomation_otherreturnincome,IncomeInfomation_pensioninsurance,IncomeInfomation_productionincome,IncomeInfomation_salary,IncomeInfomation_shengchengincome,IncomeInfomation_totalincome,IncomeInfomation_transferincome,fID,version","relationTypes":"String,Float,Decimal,Float,Integer,Float,Float,String,Decimal,Float,Float,Float,Decimal,Float,String,String,Integer","relations":"grid_poveryFamilyIncomeInfomation.IncomeInfomation_ID,grid_poveryFamilyIncomeInfomation.IncomeInfomation_averageincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_caichanincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_ecologicalcompensation,grid_poveryFamilyIncomeInfomation.IncomeInfomation_familyID,grid_poveryFamilyIncomeInfomation.IncomeInfomation_familyplanningincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_fiveguarantees,grid_poveryFamilyIncomeInfomation.IncomeInfomation_lowsecurityincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_otherreturnincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_pensioninsurance,grid_poveryFamilyIncomeInfomation.IncomeInfomation_productionincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_salary,grid_poveryFamilyIncomeInfomation.IncomeInfomation_shengchengincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_totalincome,grid_poveryFamilyIncomeInfomation.IncomeInfomation_transferincome,grid_poveryFamilyIncomeInfomation.fID,grid_poveryFamilyIncomeInfomation.version","sys.rowid":"grid_poveryFamilyIncomeInfomation","updateMode":"whereVersion"}}},"process":"/grid/povertyPeople/process/povertyPeople/povertyPeopleProcess"}]}
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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO grid_poveryFamilyIncomeInfomation grid_poveryFamilyIncomeInfomation(grid_poveryFamilyIncomeInfomation, grid_poveryFamilyIncomeInfomation.version, grid_poveryFamilyIncomeInfomation.IncomeInfomation_ID, grid_poveryFamilyIncomeInfomation.IncomeInfomation_averageincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_caichanincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_ecologicalcompensation, grid_poveryFamilyIncomeInfomation.IncomeInfomation_familyID, grid_poveryFamilyIncomeInfomation.IncomeInfomation_familyplanningincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_fiveguarantees, grid_poveryFamilyIncomeInfomation.IncomeInfomation_lowsecurityincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_otherreturnincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_pensioninsurance, grid_poveryFamilyIncomeInfomation.IncomeInfomation_productionincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_salary, grid_poveryFamilyIncomeInfomation.IncomeInfomation_shengchengincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_totalincome, grid_poveryFamilyIncomeInfomation.IncomeInfomation_transferincome, grid_poveryFamilyIncomeInfomation.fID) VALUES (:grid_poveryFamilyIncomeInfomation, :version, :IncomeInfomation_ID, :IncomeInfomation_averageincome, :IncomeInfomation_caichanincome, :IncomeInfomation_ecologicalcompensation, :IncomeInfomation_familyID, :IncomeInfomation_familyplanningincome, :IncomeInfomation_fiveguarantees, :IncomeInfomation_lowsecurityincome, :IncomeInfomation_otherreturnincome, :IncomeInfomation_pensioninsurance, :IncomeInfomation_productionincome, :IncomeInfomation_salary, :IncomeInfomation_shengchengincome, :IncomeInfomation_totalincome, :IncomeInfomation_transferincome, :fID)
    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.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)
    ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO grid_poveryfamilyincomeinfomation (grid_poveryfamilyincomeinfomation.fID, grid_poveryfamilyincomeinfomation.VERSION, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_ID, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_AVERAGEINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_CAICHANINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_ECOLOGICALCOMPENSATION, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_FAMILYID, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_FAMILYPLANNINGINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_FIVEGUARANTEES, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_LOWSECURITYINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_OTHERRETURNINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_PENSIONINSURANCE, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_PRODUCTIONINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_SALARY, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_SHENGCHENGINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_TOTALINCOME, grid_poveryfamilyincomeinfomation.INCOMEINFOMATION_TRANSFERINCOME, grid_poveryfamilyincomeinfomation.FID) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [2CD6DA0E420A4FA1AAEC902EF04106F7, 0, null, 10.5, null, null, 2050, 4.0, 6.0, 5, null, null, 2.0, 1.0, null, 21.0, 3, null]出错
    at com.justep.exception.BusinessException.create(Unknown Source)
    at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
    ... 36 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column 'fID' specified twice
    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:980)
    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)
    ... 37 more




Column 'fID' specified twice

总共17个关系,怎么这个fid就出现了两次,变成了18个关系??  是因为当时改了ontology中该概念的一个关系的类型吗     怎么解决

20

主题

56

帖子

106

积分

初级会员

Rank: 2

积分
106
QQ
 楼主| 发表于 2017-11-16 14:02:04 | 显示全部楼层
savedata
回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35942
发表于 2017-11-16 14:33:11 | 显示全部楼层
把概念和queryAction的定义发一下看看
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-17 14:20 , Processed in 0.065418 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表