up vote 1 down vote favorite
share [fb]

I am getting this error when compiling my java program

  java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Then I knew that I should add the path of "mysql-connector-java-3.1.14-bin.jar" to the java classpath. I am using windows XP, I edited the classpath in the controlpanel/system/enviromental variables

the classpath was : .;C:\j2sdk1.4.2_16\jre\lib;

so now it became : .;C:\j2sdk1.4.2_16\jre\lib;C:\Program Files\mysql-connector-java-3.1.144

however, i still get the same error, moreover, when I type set classpath in the cmd ( just to check what is the current classpath ) i get :

CLASSPATH= .;C:\j2sdk1.4.2_16\jre\lib;

can anyone help me fix this ?

link|improve this question
79% accept rate
maybe you missed .jar extension while editing classpath. – vishwanath Nov 20 '10 at 13:56
3  
Did you restart cmd after making the change? – Hippo Nov 20 '10 at 13:57
2  
As a side note, I wouldn't add the classpath to mysql-connector to the CLASSPATH variable. You should simply specify this dependency directly: java -cp "C:\program files\mysql-connector..." com.yourcompany.MainClass – ripper234 Nov 20 '10 at 14:03
feedback

1 Answer

up vote 5 down vote accepted

You have to put the full path to the jarfile in the classpath (including the filename):

.;C:\j2sdk1.4.2_16\jre\lib;
C:\Program Files\mysql-connector-java-3.1.144\mysql-connector-java-3.1.14-bin.jar

As Hippo said, you have to restart cmd after changing that. If it doesn't work, launch your program like this:

java -cp ".;C:\j2sdk1.4.2_16\jre\lib;
C:\Program Files\mysql-connector-java-3.1.144\mysql-connector-java-3.1.14-bin.jar"
my.class.Name
link|improve this answer
thank you it worked !! – SLA Nov 20 '10 at 14:22
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.