Document

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
posted @ 2022-08-29 11:31  lsepi  阅读(82)  评论(0编辑  收藏  举报