有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

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) 个答案