CODEWITHSUNDEEP
jdbcjmeter
Dingo
Dingo

Reputation: 31

Can not load JDBC driver. in

Test Plan.

  1. Add one Thread Group with default settings.

  2. Add JDBC Connection Configuration with below setting.

    enter image description here

  3. Add JDBC Requset for Simple select stement.

  4. Add Constant Timer with 5000 miliseconds Thread Delay.

  5. Add View Results Tree.

My DBServer Name : proddbtest1.xyz.com SQL Instance Name: Prodbtest1\LIVE

I fill up this parameter value in DB URL and Driver class. In fact I download latest JDBC sqljdbc42.jar from Net and past at Lib folder. After running my test plan still I get an error message

"java.sql.SQLException: Cannot load JDBC driver class com.microsoft.jdbc.sqlserver.SQLServerDriver"

Can any one help me where I am passing wrong configuration settings.

Upvotes: 1

Views: 10162

Answers (1)

Dmitri T
Dmitri T

Reputation: 168197

As per Using the JDBC Driver article the correct Microsoft JDBC Driver class name is:

com.microsoft.sqlserver.jdbc.SQLServerDriver

you are trying to use the following one:

com.microsoft.jdbc.sqlserver.SQLServerDriver
              ^^^^^^^^^^^^^^

So replace jdbc and sqlserver and your setup will work.

Also don't forget to restart JMeter to pick the sqljdbc42.jar up.

Just in case see The Real Secret to Building a Database Test Plan With JMeter article to learn more about database load testing using JMeter

Upvotes: 3

Related Questions