Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you