Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Atlassian-log-analysis returning java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLS

Lesley Freemonth
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 7, 2020

Hello,

we are trying to test some database performance issues when we upgrade from 7.3 to 8.5.3. we are trying to use the atlassian-log-analysis-0.1.1.jar as referenced Here to generate a comprehensive output but we are hitting a snag.

here is the code we are using

D:\JIRA>.\jre\bin\java -cp D:\atlassian-log-analysis-0.1.1.jar;.\lib\mssql-jdbc-7.2.1.jre8 ^
com.atlassian.util.benchmark.JIRASQLPerformance ^
JIRADBUSERNAME JIRADBPASSWORD ^
jdbc:sqlserver://;serverName=uswegpsqld09;portNumber=1433;databaseName=jiradb com.microsoft.sqlserver.jdbc.SQLServerDriver ^
> db-perf-test.txt

 The error we receive is this.

Usage: java com.atlassian.util.benchmark.JIRASQLPerformance user password url driverClass [noOfRuns]
Exception in thread "main" java.lang.IllegalArgumentException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at com.atlassian.util.benchmark.ConnectionFactory.<init>(ConnectionFactory.java:21)
at com.atlassian.util.benchmark.JIRASQLPerformance.main(JIRASQLPerformance.java:40)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.atlassian.util.benchmark.ConnectionFactory.<init>(ConnectionFactory.java:17)
... 1 more

I am at a loss for what to do next. just an FYI, the SQL server is on a different VM than the Application server. when we run the equivlenet code on the old application server, which has the SQL server installed together on the same VM, it runs perfectly fine. 

What am i doing wrong?

1 answer

0 votes
Gonchik Tsymzhitov
Community Champion
January 7, 2021

hm, driver has not been recognized. 

Also, uploaded the code here for the easier test it

https://github.com/AUGSpb/atlassian-support-benchmark

Suggest an answer

Log in or Sign up to answer