问题描述
我遇到了问题
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'列数据被截断
请帮帮我
这篇关于数据截断的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!