新增时，字段为中文时报错

钟新 · 发表于 2018-11-14 14:27:28

新增时，字段为中文的时候报错

jishuang · 发表于 2018-11-14 14:30:50

数据库中的字段名是中文？
data目录下mapping文件中设置关系和中文字段对应

钟新 · 发表于 2018-11-14 14:35:24

name 处，中文保存不了，英文可以

jishuang · 发表于 2018-11-14 14:37:11

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

钟新 · 发表于 2018-11-14 14:43:12

2018-11-14 14:42:50 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveST_StuAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"fAge":{"changed":"1","value":"12"},"fName":{"changed":"1","value":"嗡嗡嗡"},"userdata":{"id":{"value":"EAB2531DB4604E5895451B05A8E2DAE4"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}}],"userdata":{"idColumnDefine":"ST_Stu","idColumnName":"ST_Stu","idColumnType":"String","model":"/student/info/data","relationAlias":"fAge,fName,version","relationTypes":"Integer,String,Integer","relations":"ST_Stu.fAge,ST_Stu.fName,ST_Stu.version","sys.count":4,"sys.rowid":"ST_Stu","updateMode":"whereVersion"}}},"process":"/student/info/process/info/infoProcess"}]}
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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 ST_Stu ST_Stu(ST_Stu, ST_Stu.version, ST_Stu.fAge, ST_Stu.fName) VALUES (:ST_Stu, :version, :fAge, :fName)
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)
... 29 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO ST_STU (ST_STU.fID, ST_STU.VERSION, ST_STU.FAGE, ST_STU.FNAME) VALUES ( ? , ? , ? , ? ), binds: [EAB2531DB4604E5895451B05A8E2DAE4, 0, 12, 嗡嗡嗡]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 38 more
Caused by: java.sql.SQLException: Incorrect string value: '\xE5\x97\xA1\xE5\x97\xA1...' for column 'fName' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
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)
... 39 more

jishuang · 发表于 2018-11-14 14:46:33

Incorrect string value: '\xE5\x97\xA1\xE5\x97\xA1...' for column 'fName' at row 1

这个是数据库的标准报错信息，可以到网上查找解决方案
https://blog.csdn.net/ch717828/article/details/41357431/

平台默认需要的utf-8的编码格式

		自动登录	找回密码
密码			注册

[处理中] 新增时，字段为中文时 报错

[处理中] 新增时，字段为中文时报错