You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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?
hm, driver has not been recognized.
Also, uploaded the code here for the easier test it
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.