setting classpath for mysql java connector in linux

[sbutt]

I have read various articles on setting classpath in linux, but couldn't get through and I am still unclear as to how to set the classpath in linux?

I even copied the 'mysql-connector-java-5.1.22-bin.jar' in my project src folder where the .class file is generated but still no success.

I also tried setting the classpath at runtime by: export CLASSPATH=/opt/integra/middleware/LCPAnalyzer/src/mysql-connector-java-5.1.22-bin.jar

but then i got the NoClassDefFoundError exception:

[Rubberman]

There are two ways to set the classpath. One is to use the environment variable CLASSPATH. The other is to specify the classpath option on the Java command line. For the environment to work, you need ALL of the paths to jar files needed. When I started doing serious Java development earlier this year, this was a major part of my learning curve...

[nicephotog]

CLASSPATH variable can be set in user /etc/proc file to automatically be looked for to run a java program. If its web server then put the jar in /WEB-INF/lib of the application.
for commandline -cp or -classpath is a ; separated list after classpath.
run on the command terminal
java -h and look at the options.