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

java jdbc classpath classnotfoundexception
SLA picture SLA · Nov 20, 2010 · Viewed 47k times · Source

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 ?

Answer

thejh picture thejh · Nov 20, 2010

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

Related questions

How to connect SQLite with Java?

I am using one simple code to access the SQLite database from Java application . My code is import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class ConnectSQLite { public static void main(…

Read More
Why I can't get the org.h2.Driver? I use maven

I face a problem about connecting to H2 this is my pom.xml: <project> <modelVersion>4.0.0</modelVersion> <groupId>.</groupId> <artifactId>dbConnection</artifactId> <name>Db Connection&…

Read More
Postgres : No suitable Driver found for jdbc

I know this might be a possible duplicate of question posted here. Sorry for that.Here is the code i wrote for Database connection try{ Class.forName("org.postgresql.Driver"); } catch(ClassNotFoundException e) { e.printStackTrace(); } try{ String URL = "jdbc:posgresql://…

Read More