求助

laquyen

我设计1个管理，查询没问题，点新增记录就出错。请高手指教。查了论坛的方法，还是不行。其中YGDJGL是数据表的名称，也就是概念名称。
详细：
编码: JUSTEP150146; 提示: 设置将列"YGDJGL"的值为"58A6480A91944AEDAA23C599DFFED83E"时出错
java.lang.String

---

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)
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: com.justep.exception.BusinessException: 编码: JUSTEP150146; 提示: 设置将列"YGDJGL"的值为"58A6480A91944AEDAA23C599DFFED83E"时出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.RowImpl.setValue(Unknown Source)
at com.justep.system.data.BizData.create(Unknown Source)
at BizProcedure.create(BizProcedure.java:22)
... 26 more
Caused by: java.lang.ClassCastException: java.lang.String
... 29 more

url:/UI/system/service/common/bizAction.j
param:{"process":"/GYS/YGDJGL/process/YGDJGL/yGDJGLProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"createYGDJGLAction","parameters":{"table":{"@type":"table","userdata":{"concept":"YGDJGL","relations":"YGDJGL.UPDATED,YGDJGL.CREATED,YGDJGL.CREATORNUM,YGDJGL.CREATORNAME,YGDJGL.UPDATORNUM,YGDJGL.UPDATORNAME,YGDJGL.ATTACHMENTPATH,YGDJGL.COL_XINGMING,YGDJGL.COL_JIGUAN,YGDJGL.COL_NIANLING,YGDJGL.COL_MINZU,YGDJGL.COL_XINGBIE,YGDJGL.COL_XUEXING,YGDJGL.COL_CHUSHENGRIQI,YGDJGL.COL_SHENTIZHUANGKUANG,YGDJGL.COL_HUNYINZHUANGKUANG,YGDJGL.COL_SHENFENZHENGHAOMA,YGDJGL.COL_SHENFENZHENGDIZHI,YGDJGL.COL_XIANZHUZHI,YGDJGL.COL_GONGZUODANWEI,YGDJGL.COL_ZHIWEI,YGDJGL.COL_SHOUJI,YGDJGL.COL_BANGONGDIANHUA,YGDJGL.COL_JIATINGDIANHUA,YGDJGL.COL_DIANZIYOUXIANG,YGDJGL.COL_MSN,YGDJGL.COL_QQ,YGDJGL.COL_XUELI,YGDJGL.COL_SHENFEN,YGDJGL.COL_XUEXIZHUANYE,YGDJGL.COL_BIYEYUANXIAO,YGDJGL.COL_XINYANG,YGDJGL.COL_GUIYISHIJIAN,YGDJGL.COL_FAMING,YGDJGL.COL_GUIYISHIFU,YGDJGL.COL_GUIYIDIDIAN,YGDJGL.COL_FAXINCANYUDIYIGONGFUWU1,YGDJGL.COL_YIGONGFUWUQITA,YGDJGL.COL_JIANLI,YGDJGL.COL_XIANGPIAN,YGDJGL.COL_BIANHAO,YGDJGL.VERSION","model":"/GYS/YGDJGL/data","conceptAlias":"YGDJGL","idColumnName":"YGDJGL","idColumnType":"Integer","idColumnDefine":"YGDJGL","relationAlias":"UPDATED,CREATED,CREATORNUM,CREATORNAME,UPDATORNUM,UPDATORNAME,ATTACHMENTPATH,COL_XINGMING,COL_JIGUAN,COL_NIANLING,COL_MINZU,COL_XINGBIE,COL_XUEXING,COL_CHUSHENGRIQI,COL_SHENTIZHUANGKUANG,COL_HUNYINZHUANGKUANG,COL_SHENFENZHENGHAOMA,COL_SHENFENZHENGDIZHI,COL_XIANZHUZHI,COL_GONGZUODANWEI,COL_ZHIWEI,COL_SHOUJI,COL_BANGONGDIANHUA,COL_JIATINGDIANHUA,COL_DIANZIYOUXIANG,COL_MSN,COL_QQ,COL_XUELI,COL_SHENFEN,COL_XUEXIZHUANYE,COL_BIYEYUANXIAO,COL_XINYANG,COL_GUIYISHIJIAN,COL_FAMING,COL_GUIYISHIFU,COL_GUIYIDIDIAN,COL_FAXINCANYUDIYIGONGFUWU1,COL_YIGONGFUWUQITA,COL_JIANLI,COL_XIANGPIAN,COL_BIANHAO,VERSION","relationTypes":"DateTime,DateTime,String,String,String,String,String,String,String,Decimal,String,String,String,DateTime,String,String,String,String,String,String,String,Decimal,Decimal,Decimal,String,String,Decimal,String,String,String,String,String,DateTime,String,String,String,String,String,Text,String,Decimal,Integer","updateMode":"whereVersion"},"rows":[]},"defaultValues":{}},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"YGDJGL","sequence":"UPDATED,CREATED,CREATORNUM,CREATORNAME,UPDATORNUM,UPDATORNAME,ATTACHMENTPATH,COL_XINGMING,COL_JIGUAN,COL_NIANLING,COL_MINZU,COL_XINGBIE,COL_XUEXING,COL_CHUSHENGRIQI,COL_SHENTIZHUANGKUANG,COL_HUNYINZHUANGKUANG,COL_SHENFENZHENGHAOMA,COL_SHENFENZHENGDIZHI,COL_XIANZHUZHI,COL_GONGZUODANWEI,COL_ZHIWEI,COL_SHOUJI,COL_BANGONGDIANHUA,COL_JIATINGDIANHUA,COL_DIANZIYOUXIANG,COL_MSN,COL_QQ,COL_XUELI,COL_SHENFEN,COL_XUEXIZHUANYE,COL_BIYEYUANXIAO,COL_XINYANG,COL_GUIYISHIJIAN,COL_FAMING,COL_GUIYISHIFU,COL_GUIYIDIDIAN,COL_FAXINCANYUDIYIGONGFUWU1,COL_YIGONGFUWUQITA,COL_JIANLI,COL_XIANGPIAN,COL_BIANHAO,VERSION"}}}
at (http://localhost:8080/x5/$v2457_d/base/base.js?language=zh_CN:1)

这是表结构：
USE [GYS]
GO
/****** 对象:  Table [dbo].[YGDJGL]    脚本日期: 03/20/2014 13:59:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[YGDJGL](
        [fID] [int] NOT NULL,
        [UPDATED] [datetime] NULL,
        [CREATED] [datetime] NULL,
        [CREATORNUM] [varchar](254) COLLATE Chinese_PRC_CI_AS NULL,
        [CREATORNAME] [varchar](254) COLLATE Chinese_PRC_CI_AS NULL,
        [UPDATORNUM] [varchar](254) COLLATE Chinese_PRC_CI_AS NULL,
        [UPDATORNAME] [varchar](254) COLLATE Chinese_PRC_CI_AS NULL,
        [ATTACHMENTPATH] [varchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XINGMING] [varchar](30) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_JIGUAN] [varchar](30) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_NIANLING] [decimal](18, 0) NULL,
        [COL_MINZU] [varchar](30) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XINGBIE] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XUEXING] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_CHUSHENGRIQI] [datetime] NULL,
        [COL_SHENTIZHUANGKUANG] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_HUNYINZHUANGKUANG] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_SHENFENZHENGHAOMA] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_SHENFENZHENGDIZHI] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XIANZHUZHI] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_GONGZUODANWEI] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_ZHIWEI] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_SHOUJI] [decimal](18, 0) NULL,
        [COL_BANGONGDIANHUA] [decimal](18, 0) NULL,
        [COL_JIATINGDIANHUA] [decimal](18, 0) NULL,
        [COL_DIANZIYOUXIANG] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_MSN] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_QQ] [decimal](18, 0) NULL,
        [COL_XUELI] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_SHENFEN] [varchar](30) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XUEXIZHUANYE] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_BIYEYUANXIAO] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XINYANG] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_GUIYISHIJIAN] [datetime] NULL,
        [COL_FAMING] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_GUIYISHIFU] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_GUIYIDIDIAN] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_FAXINCANYUDIYIGONGFUWU1] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_YIGONGFUWUQITA] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_JIANLI] [text] COLLATE Chinese_PRC_CI_AS NULL,
        [COL_XIANGPIAN] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
        [COL_BIANHAO] [decimal](18, 0) NULL,
        [VERSION] [int] NULL,
PRIMARY KEY CLUSTERED
(
        [fID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO

zxzhzqx

你设置赋值的  数据类型不对吧？界面上有没赋值，或者 在 ontology上有没设置默认值，再看看  YGDJGL这个字段长度是否够长

fpj123

楼主，把TOMCAT的信息贴出来，帮你分析一下。

fpj123

你也可以这样操作一下：
1.在ontology文件概念中检查一下这个字段的关系类型是否正确
2.检查一下是否是默认值得问题

laquyen

zxzhzqx 发表于 2014-3-20 12:12
你设置赋值的  数据类型不对吧？界面上有没赋值，或者 在 ontology上有没设置默认值，再看看  YGDJGL这个字 ...

YGDJGL不是字段，是表名称。界面上有没赋值？在哪查呢？

laquyen

fpj123 发表于 2014-3-20 12:27
楼主，把TOMCAT的信息贴出来，帮你分析一下。

贴上了，请帮忙。多谢！

zxzhzqx

laquyen 发表于 2014-3-20 13:59
贴上了，请帮忙。多谢！

fID类型错了，不是int类型的，改varchar类型的

zxzhzqx

laquyen 发表于 2014-3-20 13:59
贴上了，请帮忙。多谢！

如果要用int类型的  ，需要在 ontology里--映射类型 ---- 主键  里把fID类型改为Integer 然后 在概念设置里 ，把主键默认值改为  流水自增的  如图：

laquyen

按你的思路，没提示出错了，多谢！

laquyen

zxzhzqx 发表于 2014-3-20 14:14
如果要用int类型的  ，需要在 ontology里--映射类型 ---- 主键  里把fID类型改为Integer 然后 在概念设置 ...

按你的思路，没提示出错了，多谢！