Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' using Jmeter

3
votes

I have set up all my thread groups,jdbc config connection and jdbc request correctly along with all the required jar files in the same folder where apache jmeter is installed but I am not sure why I keep getting the below response in the View Results Tree when I try running a simple SQL command. I have googled so much on internet but I couldn't find any resolution for this error. Could somebody who has JMeter expertise help me in solving this problem. Thank you so much in advance.

Error :-

 Response message: java.sql.SQLException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ':jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'

JDBC Connection Config:-

Database URL: :jdbc:sqlserver://ABC\SQL2016:59954;databaseName=Mydatabasename
JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

enter image description here

1
sql-serverapachejdbcjmetersql-server-2016
MS SQL Server JDBC Jar file present in the correct location? - Norbert van Nobelen
yes both sqljdbc and sqljdbc4 executable jar files are present in apache-jmeter-3.2\lib folder. - Teja
Try removing the sqljdbc file: There might be a difference in the instantiation there which could cause an issue. - Norbert van Nobelen
still the same.. i closed and reopened jmeter. - Teja
Ok. Interesting. The DB URL starts with a :. Typo or unhandy log output? - Norbert van Nobelen

1 Answers

2
votes

Remove extra :

 connect URL 'jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'