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

Lesley Freemonth 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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