0

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

Ori Marko
  • 56,308
  • 23
  • 131
  • 233
Anil Kumar
  • 1
  • 3

1 Answers1

1

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

Ori Marko
  • 56,308
  • 23
  • 131
  • 233
  • Can you please let me know that how to use the retrieved value from Database in an HTTP login request? Currently, I am trying to log in with, two variables username and password, mentioned in JDBC request but not able to log in. Even I tried with username_1, password_1 but getting the same issue. I am running these request in a single thread. – Anil Kumar Jun 13 '18 at 12:46
  • @Anil Kumar you can't, you must first set it in JDBC connection. If it's a new question, ask a new question with more details – Ori Marko Jun 13 '18 at 13:00