Connection Exception In Jmeter

0
votes

I am just setting up a JDBC connection using Jmeter and MySQL. I downloaded the jar file and placed the same file in Lib folder of Jmeter. After that, I created a JDBC Connection Configuration and JDBC request. I have also added a View result tree listener.

When I am running the request getting following error: "Cannot create PoolableConnectionFactory (The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)"please refer to image

1
mysqljdbcjmeter
what's your jar version? see stackoverflow.com/questions/26515700/… – user7294900
mysql-connector-java-8.0.11.jar – Anil Kumar
try to add to database URL ?serverTimezone=UTC – user7294900
Thanks, It worked. – Anil Kumar

1 Answers

1
votes

In MySQL you can define time zone in database URL, it is been reported as an issue here

You can add to JMeter's JDBC Database URL field at the end ?serverTimezone=UTC