How to resolve error "Cannot load JDBC driver class" displayed in jmeter 4.0

jmeter jmeter-4.0
Praveen PS picture Praveen PS · Apr 9, 2018 · Viewed 8.3k times · Source

I recently updated to jmeter 4.0 from jmeter 3.2. In jmx file, i have query to execute and it was running fine in jmeter 3.2 . But the jmx file fails with error "Response message: java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'" in jmeter 4.0. Please help me in resolving this issue.

below is the screenshot of JDBC Connection ConfigurationJDBC connection config

Answer

Dmitri T picture Dmitri T · Apr 9, 2018

You need to

  1. Download Microsoft JDBC Driver for SQL Server
  2. Extract mssql-jdbc-x.x.x.jrex.jar somewhere to JMeter Classpath
  3. Restart JMeter to pick the .jar up

See Building a Database Test Plan and How to use Different JDBC Drivers articles for more details on how to use JMeter for database testing.

Related questions

Workbench section not showing in apache jmeter

I am new to jmeter. I successfully installed jmeter into my windows machine. I opened "jmeter.bat" under apache-jmeter-4.0\bin. But the jmeter window is not showing the workbench section in the left panel. I have attached the screenshot below …

Read More
JMETER_HOME environment variable is not defined

I tried to execute JMeter 4.0 from the command prompt in Windows 7. I got the following error during execution: The JMETER_HOME environment variable is not defined correctly This environment variable is needed to run this program I set C:\apache-jmeter-4.0\…

Read More
JMeter 4 - can't execute jmeter-server in windows 7

I download latest JMeter 4, As part of Remote Testing To run JMeter in remote node, start the JMeter server component on all machines you wish to run on by running the JMETER_HOME/bin/jmeter-server (unix) or JMETER_HOME/bin/…

Read More