Getting "Cannot load JDBC Driver Class" error while trying to connect with Database - Jmeter

Question

In Jmeter, i have entered the database configuration (database URL, JDBC Driver class, username & password) for JDBC connection and also declared variable name of pool in JDBC Request as well. I have also updated the SQL Query and Query type. But, when i run i am getting response message "java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'.

Answer 1

As per documentation:

You will need to add your database vendor's JDBC driver to the classpath if you want to do JDBC testing. Make sure the file is a jar file, not a zip.

So you will need to download MySQL Connector/J and drop the .jar file to "lib" folder of your JMeter installation. JMeter restart will be required to pick up the .jar

Alternatively you can configure the path to the JDBC .jar in Test Plan level, in this case restart will not be required

More information: How to Test MySQL Connection