mysql java。sql。SQLException:无法将值“20200816 17:33:21.690”从第18列转换为时间戳
我得到以下例外。但很少有行能够从结果集中获取值并映射到JavaPOJO。有人能帮我调试一下吗
java.sql.SQLException: Cannot convert value '2020-08-16 17:33:21.690' from column 18 to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1336)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:575)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6686)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6005)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4961)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5011)
at com.freeware.gridtag.DBGrid.getColumnValue(DBGrid.java:712)
at com.freeware.gridtag.DBGrid.drawGridWithOutColumns(DBGrid.java:2550)
at com.freeware.gridtag.DBGrid.doEndTag(DBGrid.java:600)
at org.apache.jsp.mainReport_jsp._jspService(mainReport_jsp.java:725)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
Caused by: java.lang.NumberFormatException: 0000_15975991715696�8SMPPMTTX2020-08-16 17:33:21.647
TRAFFIC-SPLIT2020-08-16 19:13:21.690Venu-Traffic-Split-On-net2020-08-16 17:52:41.877311110
HANDSET_ACK2020-08-16 17:33:21.6902020-08-16 17:33:21.6902020-08-16 17:52:40.000lid:1915976003605490 sub:001 dlvrd:001 submit date:2008161752 done date:2008161752 stat:DELIVRD err:000 text:3310
at com.mysql.jdbc.StringUtils.getInt(StringUtils.java:756)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1114)
... 54 more
感谢您的帮助
共 (0) 个答案