主从表保存时，报JUSTEP150210的从表错误

asia668 · 发表于 2018-8-22 17:03:04

本帖最后由 asia668 于 2018-8-22 17:03 编辑

1.单个主表或从表，数据可正常保存；
2.主从表同时维护时，保存时，报JUSTEP150210；请帮忙指导，是哪里配置错误呢？谢谢！

错误信息：
执行KSQL出错, KSQL: INSERT INTO Eabb_file Eabb_file(Eabb_file, Eabb_file.version, Eabb_file.eabb01, Eabb_file.eabb03, Eabb_file.eabb04, Eabb_file.eabb05, Eabb_file.eabb05_fac, Eabb_file.eabb06, Eabb_file.eabb07, Eabb_file.eabb08, Eabb_file.eabb09, Eabb_file.eabb091)
编码：JUSTEP150210
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor162.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.Http11AprProcessor.process(Http11AprProcessor.java:879) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774) at java.lang.Thread.run(Thread.java:745) Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO Eabb_file Eabb_file(Eabb_file, Eabb_file.version, Eabb_file.eabb01, Eabb_file.eabb03, Eabb_file.eabb04, Eabb_file.eabb05, Eabb_file.eabb05_fac, Eabb_file.eabb06, Eabb_file.eabb07, Eabb_file.eabb08, Eabb_file.eabb09, Eabb_file.eabb091) VALUES (:Eabb_file, :version, :eabb01, :eabb03, :eabb04, :eabb05, :eabb05_fac, :eabb06, :eabb07, :eabb08, :eabb09, :eabb091) 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 eabb_file (eabb_file.fID, eabb_file.VERSION, eabb_file.EABB01, eabb_file.EABB03, eabb_file.EABB04, eabb_file.EABB05, eabb_file.EABB05_FAC, eabb_file.EABB06, eabb_file.EABB07, eabb_file.EABB08, eabb_file.EABB09, eabb_file.EABB091) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [5B33845775D946928732F55A2DDC07F9, 0, 2CAE090AE9BA41AEB58AD514DDE228F4, 1, 1, 1, 1, null, null, null, null, null]出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source) ... 38 more Caused by: java.sql.DataTruncation: Data truncation at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ... 39 more