JMeterMysql查询报错Cannot convert value '2021-12-16 16:30:16.880' from column 7 to TIMESTAMP.
问题现象
使用JMeter连接Mysql查询时,部分请求报错:Cannot convert value '2021-12-16 16:30:16.880' from column 7 to TIMESTAMP.
解决方案
在JDBC Connection Configuration的url中添加useFastDateParsing=false
jdbc:mysql://IP:port/DatabaseName?allowMultiQueries=true&useFastDateParsing=false