Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' error display while running JMeter load test in VSTS

Question

I am trying to run the JMeter load test in VSTS. As this load test runs successfully on my local machine, but displays an error message while using VSTS. I am using JDBC Connection Configuration step to create a connection with SQL server database.

Error

2019-12-12 11:58:14,882 WARN o.a.j.p.j.p.AbstractJDBCProcessor: SQL Problem in JDBC PostProcessor: java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

score 1 · Accepted Answer · answered Dec 13 '19 at 10:56

1

What you can do is to just simply include the required jar files(in this case jdbc driver jar) along with the other supported files(e.g any csv file for data).

answered Dec 13 '19 at 10:56

Santosh sanwal

134
1
4
15

Perfect. Thanks. – rAJ Dec 13 '19 at 11:41

score 0 · Answer 2 · answered Dec 13 '19 at 10:01

This message usually means that the jar file for class com.microsoft.sqlserver.jdbc.SQLServerDriver was not found in VSTS classpath.

Have a look at this thread which sheds some light on how to achieve this:

Visual Studio Code, Java Extension, howto add jar to classpath

Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' error display while running JMeter load test in VSTS

2 Answers2