时间解析报错

java.sql.SQLException:无法将值’2023-07-29 19:37:34.000‘从第2列转换为时间戳

java.sql.SQLException: Cannot convert value '2023-07-29 19:37:34.000000' from column 2 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)

问题原因： 无法将数据库时间值转换为TIMESTAMP，这是com.mysql.jdbc.ResultSetRow.getTimestampFast上mysql连接器中的一个bug。

解决办法

1.可以通过将useFastDateParsing=false添加到JDBC connection URL来禁用快速日期解析。

url: jdbc:mysql://39.107.193.97:3336/lwtest?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useFastDateParsing=false

2.尝试使用更高版本数据库。MySQL 5.6.4及之后版本对小数秒有额外支持。(MySQL 5.6.4之前的版本，它是在没有微秒的情况下存储的)