Monday, July 7, 2008

SwingBenchException: Oracle jdbc classes not found

Problem Description:
---------------------------------------

After running swingbench product you get the following message,

11:18:57 07/08 [EROR] UserSession com.dom.benchmarking.swingbench.kernel.SwingBenchException: Oracle jdbc classes not found

Reason of The Problem:
-----------------------------------------

The Oracle jdbc class is not found. Possibly there is wrong settings of CLASSPATH in the $SWINGHONE/swingbench.env file.

Solution of The Problem:
------------------------------------------

For example if you just install oracle instant client then change the CLASSPATH location to the point of ojdbc14.jar.
There was the settings of ,
# The following is needed for 10g environments
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/ojdbc14.jar

Now you point to your instant client and fing ojdbc14.jar. Locate the location to the CLASSPATH variable in the swingbench.env, change it to correct location and start the swingbench.

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/ojdbc14.jar

No comments:

Post a Comment