数据截断

扫码查看
本文介绍了数据截断的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我遇到了问题


com.mysql.jdbc.MysqlDataTruncation:数据截断:第1行的FGiroNPagDol列截断数据

在com.mysql.jdbc.SQLError.convertShowWarningsToSQLWa rnings(SQLError.java:717)

at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncati on(MysqlIO.java:3183)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1874)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1313)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1585)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1500)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1485)

at packapp.Desempaquetar.grabarEnTablaGiros(Desempaqu etar.java:872)

at packapp.Operaciones.desempaquetar(Operaciones.jav a:333)

at packinterfaz.servletinterfaz.ProcesarArchivo.proce ssRequest(ProcesarArchivo.java:156)

at packinterfaz.servletinterfaz.ProcesarArchivo.doPos t(ProcesarArchivo.java: 266)

在javax.servlet.http.HttpServlet.service(HttpServlet .java:710)

在javax.servlet.http.HttpServlet.service(HttpServlet .java: 803)

org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.do过滤(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:210)

at org.apache.catalina .core.StandardContextValve.invo ke(StandardContextValve.java:174)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apac的
he.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:108)

org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:151)

at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:870)

org.apache.coyote.http11.Http11BaseProtocol $ Http11 ConnectionHandler.processConnection(Http11BaseProt ocol。 java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util .net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool $ ControlR unnable.run(ThreadPool.java:685)
java.lang.Thread.run上的
(Thread.java:595)

错误=数据截断:第1行的'FGiroNPagDol'列数据被截断



请帮帮我

解决方案






这篇关于数据截断的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-27 23:32
查看更多