ClassNotFoundException: com.atlassian.util.benchmark.JIRASQLPerformance

Question

Hi,

I tried to run JIRASQLPerformance utility and got the following error:

C:\Atlassian\JIRA-4.4>java -cp atlassian-log-analysis-0.1.1.jar:/Atlassian/JIRA-
4.4/lib/mysql-connector-java-5.1.10.jar com.atlassian.util.benchmark.JIRASQLPerf
ormance jira ********  "jdbc:mysql://localhost/jira41?useUnicode=true&amp
;characterEncoding=UTF8" com.mysql.jdbc.Driver
Exception in thread "main" java.lang.NoClassDefFoundError: com/atlassian/util/be
nchmark/JIRASQLPerformance
Caused by: java.lang.ClassNotFoundException: com.atlassian.util.benchmark.JIRASQ
LPerformance
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: com.atlassian.util.benchmark.JIRASQLPerformance.
 Program will exit.

I am running JDK 1.6.0_26b03 on Windows 2008 Server R2

Any help is much appreciated.

Thanks,

Enrico

Alex Suslin · Answer

for windows installation it should be semicolon

atlassian-log-analysis-0.1.1.jar:/

also note that in windows there are backslashes

java -cp PATH_TO_THE\atlassian-log-analysis-0.1.1.jar;PATH_TO_YOUR_JDBC_DRIVER_JAR ^
com.atlassian.util.benchmark.JIRASQLPerformance ^
YOUR_DB_USERNAME YOUR_DB_PASSWORD ^
JDBC_CONNECTION_STRING JDBC_DRIVER_CLASS ^
> db-perf-test.txt

https://confluence.atlassian.com/jirakb/testing-database-access-speed-54362302.html