点击“保存”的时候报错，报insert……的错，怎么解决呀？

zj_13983777

file:///C:\Users\zj\AppData\Roaming\Tencent\Users\1343177851\QQ\WinTemp\RichOle\QWP(GVWJ@}4}KKNZBACTJ`1.jpg ，点击“录入集团客户信息”按钮——>弹出“windowDialog”——>添加信息——>当点击“保存”的时候，就报这个错了，不知道怎么解决，项目重新启动 也不行，哪位大神帮帮忙啊

fpj

把控制台的信息发一下。

zj_13983777

fpj 发表于 2013-10-15 08:24
把控制台的信息发一下。

2013-10-15 09:13:57 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<actions><action content-type="application/json" accept="application/json, text/javascript, */*"><![CDATA[{"process":"/SA/pcmanager/process/group_map/group_mapProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"PSN01","executeContext":"","action":"saveCustomergroupAction","parameters":{"table":{"@type":"table","userdata":{"relationAlias":"version,accountID,groupNum,groupName,groupCode,groupRole,groupType,groupProduct,groupAddress,groupComeTime,groupPerson,xZhou,yZhou,groupR","relationTypes":"Integer,String,String,String,String,String,String,String,String,DateTime,String,String,String,Integer","idColumnType":"String","sys.rowid":"Customergroup","idColumnDefine":"Customergroup","idColumnName":"Customergroup","sys.count":3,"relations":"Customergroup.version,Customergroup.accountID,Customergroup.groupNum,Customergroup.groupName,Customergroup.groupCode,Customergroup.groupRole,Customergroup.groupType,Customergroup.groupProduct,Customergroup.groupAddress,Customergroup.groupComeTime,Customergroup.groupPerson,Customergroup.xZhou,Customergroup.yZhou,Customergroup.groupR","model":"/SA/pcmanager/data","updateMode":"whereVersion","concept":"Customergroup","conceptAlias":"Customergroup"},"rows":[{"userdata":{"id":{"value":"7C2BF63C01924F09B706D04F7C1A4675","originalValue":"83954CACAF8C4B178B35D5DE4ED8E03B","changed":"0"},"recordState":"new"},"version":{"value":0,"originalValue":0,"changed":"0"},"accountID":{"value":"李燕华","originalValue":"","changed":"1"},"groupNum":{"value":"324235345","originalValue":"","changed":"1"},"groupName":{"value":"金科四季城","originalValue":"","changed":"1"},"groupCode":{"value":"13983777693","originalValue":"","changed":"1"},"groupRole":{"value":"联系人","originalValue":"","changed":"1"},"groupType":{"value":"C类","originalValue":"","changed":"1"},"groupProduct":{"value":"是","originalValue":"","changed":"1"},"groupAddress":{"value":"大坪棋牌房","originalValue":"","changed":"1"},"groupComeTime":{"value":"2013-10-15T09:12:54.433Z","originalValue":"2013-10-15T09:12:54.433Z","changed":"1"},"groupPerson":{"value":"system","originalValue":"system","changed":"1"},"xZhou":{"value":"106.324","originalValue":"","changed":"1"},"yZhou":{"value":"29.7213","originalValue":"","changed":"1"},"groupR":{"value":400,"originalValue":"","changed":"1"}}]}},"translateParameter":null}]]></action></actions>
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO Customergroup Customergroup(Customergroup, Customergroup.version, Customergroup.accountID, Customergroup.groupNum, Customergroup.groupName, Customergroup.groupCode, Customergroup.groupRole, Customergroup.groupType, Customergroup.groupProduct, Customergroup.groupAddress, Customergroup.groupComeTime, Customergroup.groupPerson, Customergroup.xZhou, Customergroup.yZhou, Customergroup.groupR) VALUES (:Customergroup, :version, :accountID, :groupNum, :groupName, :groupCode, :groupRole, :groupType, :groupProduct, :groupAddress, :groupComeTime, :groupPerson, :xZhou, :yZhou, :groupR)时出错！
        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)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO customergroup (customergroup.fID, customergroup.VERSION, customergroup.ACCOUNTID, customergroup.GROUPNUM, customergroup.GROUPNAME, customergroup.GROUPCODE, customergroup.GROUPROLE, customergroup.GROUPTYPE, customergroup.GROUPPRODUCT, customergroup.GROUPADDRESS, customergroup.GROUPCOMETIME, customergroup.GROUPPERSON, customergroup.XZHOU, customergroup.YZHOU, customergroup.GROUPR) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[7C2BF63C01924F09B706D04F7C1A4675, 0, 李燕华, 324235345, 金科四季城, 13983777693, 联系人, C类, 是, 大坪棋牌房, 2013-10-15 09:12:54.433, system, 106.324, 29.7213, 400]出错！
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 35 more
Caused by: java.sql.SQLException: Duplicate entry '7C2BF63C01924F09B706D04F7C1A4675' for key 'PRIMARY'
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 36 more
-----------这是控制台报的错，我点击保存按钮的时候    控制台输出的    这是什么意思呀？

fpj

Caused by: java.sql.SQLException: Duplicate entry '7C2BF63C01924F09B706D04F7C1A4675' for key 'PRIMARY'

主键重复了。

zxzhzqx

你的windowDialog  的mapping 的主窗口操作方式是不是  新增全部了？？ 选择根据鉴别列试试

zj_13983777

zxzhzqx 发表于 2013-10-15 09:52
你的windowDialog  的mapping 的主窗口操作方式是不是  新增全部了？？ 选择根据鉴别列试试 ...

您好，这个鉴别列怎么设置呀？我只要把那个单选按钮 选上就可以了么？ ，您好 我这么写   还是不对呀

zxzhzqx

zj_13983777 发表于 2013-10-15 11:12
您好，这个鉴别列怎么设置呀？我只要把那个单选按钮 选上就可以了么？

在上面的映射关系中选择一个鉴别列，一般是 主键 ，然后下面单选  就可以了

zj_13983777

zxzhzqx 发表于 2013-10-15 11:19
在上面的映射关系中选择一个鉴别列，一般是 主键 ，然后下面单选  就可以了 ...

您好 还是不行 我是这么写的 还是报一样的错误

zxzhzqx

你两个数据集是一样的啊？？？

zj_13983777

zxzhzqx 发表于 2013-10-15 11:26
你两个数据集是一样的啊？？？

是呢，就是在主页面，有一个grid 展示 这个数据表里的数据，然后有一个添加“详细信息列表”的按钮，一点击，就弹出一个 录入信息的窗口（windowDialog）, 往这个表里添加数据