新增数据失败，设置将列“ROAD_HARDEN”的值为0时出错，

bumiaole

这个是什么问题呢？新增数据失败，设置将列“ROAD_HARDEN”的值为0时出错，报错JUETEP1501466，本来是前边都是可以用的，填着填着就报这个错了

jishuang

看tomcat控制台完整的错误信息

bumiaole

jishuang 发表于 2017-11-1 10:36
看tomcat控制台完整的错误信息

2017-11-01 10:42:06 excute stream action, params:{"accept":"application/json","a
ction":"createFbnature_villageAction","actionFlag":"__action_0__","activity":"ma
inActivity","contentType":"json","executeContext":"","executor":"","parameters":
{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"Fbnature_villa
ge","idColumnName":"Fbnature_village","idColumnType":"String","model":"/basedata
base/adminManage/data","relationAlias":"ADD_NAME,ASSIST_UNIT,AUDIT_DATE,AUDIT_PE
RSON,AUDIT_RESULT,BASKETBALL_GROUND_NUM,BODY_BUILDING,BODY_BUILD_FACILITY,BUS,CA
TV,CLASSIFY,CLEANER_NUM,DUMPCART_NUM,ESTABLISH_COUNCIL,ESTABLISH_FUND,ESTABLISH_
SYSTEM,EXAMPLE_TYPE,EXAMPLE_TYPE2,EXAMPLE_TYPE3,EXAMPLE_TYPE4,EXAMPLE_TYPE5,EXAM
PLE_TYPE6,EXAMPLE_TYPE7,EXAMPLE_TYPE8,EXAMPLE_TYPE9,FIRST_LEADER,GARBAGE_DISPOSE
,GARBAGE_GATHERING,GARBAGE_POOL_NUM,HOME_OF_MASSES,IMAGE_ATTACH,INTERNET,LATITUD
E,LONGITUDE,ORG,ORG_ID,PERSON_LIABLE,PERSON_RESPONSIBLE,PROPAGATE_TEAM,PUBLIC_CO
LUMN_NUM,PUBLIC_TOILET,REMARK,ROAD_HARDEN,SERVICE_CENTER,SEWAGE_DISPOSE,SEWAGE_D
ITCH,STAGE_NUM,TOILET_AMEND,TOWN_LEADER,TRUMPET_NUM,TUNNEL_HARDEN,WATER_PURIFY,W
ORK_STAFF,YEAR,version","relationTypes":"String,String,Date,String,String,Intege
r,Integer,Integer,String,String,String,Integer,Integer,String,String,String,Stri
ng,String,String,String,String,String,String,String,String,String,String,Integer
,Integer,String,String,String,Decimal,Decimal,String,String,String,String,String
,Integer,Integer,String,Decimal,String,String,String,Integer,String,String,Integ
er,Decimal,String,String,Integer,Integer","relations":"Fbnature_village.ADD_NAME
,Fbnature_village.ASSIST_UNIT,Fbnature_village.AUDIT_DATE,Fbnature_village.AUDIT
_PERSON,Fbnature_village.AUDIT_RESULT,Fbnature_village.BASKETBALL_GROUND_NUM,Fbn
ature_village.BODY_BUILDING,Fbnature_village.BODY_BUILD_FACILITY,Fbnature_villag
e.BUS,Fbnature_village.CATV,Fbnature_village.CLASSIFY,Fbnature_village.CLEANER_N
UM,Fbnature_village.DUMPCART_NUM,Fbnature_village.ESTABLISH_COUNCIL,Fbnature_vil
lage.ESTABLISH_FUND,Fbnature_village.ESTABLISH_SYSTEM,Fbnature_village.EXAMPLE_T
YPE,Fbnature_village.EXAMPLE_TYPE2,Fbnature_village.EXAMPLE_TYPE3,Fbnature_villa
ge.EXAMPLE_TYPE4,Fbnature_village.EXAMPLE_TYPE5,Fbnature_village.EXAMPLE_TYPE6,F
bnature_village.EXAMPLE_TYPE7,Fbnature_village.EXAMPLE_TYPE8,Fbnature_village.EX
AMPLE_TYPE9,Fbnature_village.FIRST_LEADER,Fbnature_village.GARBAGE_DISPOSE,Fbnat
ure_village.GARBAGE_GATHERING,Fbnature_village.GARBAGE_POOL_NUM,Fbnature_village
.HOME_OF_MASSES,Fbnature_village.IMAGE_ATTACH,Fbnature_village.INTERNET,Fbnature
_village.LATITUDE,Fbnature_village.LONGITUDE,Fbnature_village.ORG,Fbnature_villa
ge.ORG_ID,Fbnature_village.PERSON_LIABLE,Fbnature_village.PERSON_RESPONSIBLE,Fbn
ature_village.PROPAGATE_TEAM,Fbnature_village.PUBLIC_COLUMN_NUM,Fbnature_village
.PUBLIC_TOILET,Fbnature_village.REMARK,Fbnature_village.ROAD_HARDEN,Fbnature_vil
lage.SERVICE_CENTER,Fbnature_village.SEWAGE_DISPOSE,Fbnature_village.SEWAGE_DITC
H,Fbnature_village.STAGE_NUM,Fbnature_village.TOILET_AMEND,Fbnature_village.TOWN
_LEADER,Fbnature_village.TRUMPET_NUM,Fbnature_village.TUNNEL_HARDEN,Fbnature_vil
lage.WATER_PURIFY,Fbnature_village.WORK_STAFF,Fbnature_village.YEAR,Fbnature_vil
lage.version","updateMode":"whereVersion"}}},"process":"/basedatabase/adminManag
e/process/natureInput/natureInputProcess","translateParameter":{"cellnameByRelat
ion":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"Fb
nature_village","sequence":"ADD_NAME,ASSIST_UNIT,AUDIT_DATE,AUDIT_PERSON,AUDIT_R
ESULT,BASKETBALL_GROUND_NUM,BODY_BUILDING,BODY_BUILD_FACILITY,BUS,CATV,CLASSIFY,
CLEANER_NUM,DUMPCART_NUM,ESTABLISH_COUNCIL,ESTABLISH_FUND,ESTABLISH_SYSTEM,EXAMP
LE_TYPE,EXAMPLE_TYPE2,EXAMPLE_TYPE3,EXAMPLE_TYPE4,EXAMPLE_TYPE5,EXAMPLE_TYPE6,EX
AMPLE_TYPE7,EXAMPLE_TYPE8,EXAMPLE_TYPE9,FIRST_LEADER,Fbnature_village,GARBAGE_DI
SPOSE,GARBAGE_GATHERING,GARBAGE_POOL_NUM,HOME_OF_MASSES,IMAGE_ATTACH,INTERNET,LA
TITUDE,LONGITUDE,ORG,ORG_ID,PERSON_LIABLE,PERSON_RESPONSIBLE,PROPAGATE_TEAM,PUBL
IC_COLUMN_NUM,PUBLIC_TOILET,REMARK,ROAD_HARDEN,SERVICE_CENTER,SEWAGE_DISPOSE,SEW
AGE_DITCH,STAGE_NUM,TOILET_AMEND,TOWN_LEADER,TRUMPET_NUM,TUNNEL_HARDEN,WATER_PUR
IFY,WORK_STAFF,YEAR,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.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 Sour
ce)
        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(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150146; 提示: 设
置将列"ROAD_HARDEN"的值为"0"时出错
        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.Integer cannot be cast to jav
a.math.BigDecimal
        ... 29 more
控制台报这个错，该怎么解决呢？

jishuang

Decimal类型的设置0应该没问题，确认数据库中的字段类型是什么？
ontology中的关系具体怎么设置的

bumiaole

jishuang 发表于 2017-11-1 11:46
Decimal类型的设置0应该没问题，确认数据库中的字段类型是什么？
ontology中的关系具体怎么设置的 ...

非常感谢，虽然不知道为什么，数据库字段数据类型，和ontology都是对的，但是我去掉decimal的默认值就可以了，虽然也很想知道什么原因，如果能解答更好，但是可以结帖吧。

jishuang

decimal的默认值怎么设置的

bumiaole

jishuang 发表于 2017-11-1 16:25
decimal的默认值怎么设置的

设置为0

jishuang

你好楼主，您反馈的这个现象通过验证是产品缺陷，我们已提交到产品组(内部编号：2017110100004)，感谢楼主的支持与配合。

jishuang

Decimal类型的在ontology中设置默认值为0是如下设置：
toDecimal(0)