java.lang.ClassNotFoundException: com.mysql.jdbc.Driver When run jar file

Question

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

Hi all,
here is my sample code:

Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String userName = "root"; 
String password = "admin";
try {
  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection(url+dbName,userName,password);
  System.out.println("Connected to the database");
  conn.close();
  System.out.println("Disconnected from database");
} catch (Exception e) {
  e.printStackTrace();
}

I run in eclipse it's ok, but i built to jar file and run on command line java -jar Test.jar i get this error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at java.net.URLClassLoader$1.run(Unknown Source)
        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)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)

Please help me how to fix it.

Thanks!!!

score 1 · Answer 1 · answered Sep 28 '12 at 03:21

1

You are missing the MySQL JDBC driver .jar file, or it is not in your classpath.

answered Sep 28 '12 at 03:21

Yann Ramin

32,895
3
59
82

I all set the classpath = C:\Users\My\Downloads\mysql-connector-java-5.1.22\mysql-connector-java-5.1.22-bin.jar and add in project buildpath, but it still error. – user1024858 Sep 28 '12 at 03:47

score 1 · Answer 2 · answered Sep 28 '12 at 03:24

1

you need to put sql driver into the class path, place the driver in the same folder as your jar file and run

java -classpath mysql-connector-java-5.1.22-bin.jar -jar Test.jar

you can download mysql java driver from http://www.mysql.com/downloads/connector/j/

answered Sep 28 '12 at 03:24

Charlie Wu

7,657
5
33
40

I tried, but it still error. Are there any problem? – user1024858 Sep 28 '12 at 03:33
the class.forName bit looked odd to me, try this instead Class.forName("com.mysql.jdbc.Driver"); – Charlie Wu Sep 28 '12 at 23:54

score 1 · Answer 3 · answered Sep 28 '12 at 03:34

1

in case if you are using maven, add following dependency in your pom.xml

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.13</version>
        <classifier />
    </dependency>

answered Sep 28 '12 at 03:34

A N M Bazlur Rahman

2,280
6
38
51

Thank you for your help, but it still not work ^_^. – user1024858 Sep 28 '12 at 03:44
are you using maven dependency ? – A N M Bazlur Rahman Sep 28 '12 at 04:01
no, i don't use maven. Can you tell me which packet content this driver String driver = "com.mysql.jdbc.Driver"; Thanks! – user1024858 Sep 28 '12 at 04:22

score 0 · Answer 4 · answered Sep 28 '12 at 04:23

0

add MySQL jdbc driver jar file in to your classpath.

answered Sep 28 '12 at 04:23

Kalla

165
2
12

It also exist in my classpath , but still error. – user1024858 Sep 28 '12 at 04:59

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver When run jar file

4 Answers4

Linked