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

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!!!

Yann Ramin · Accepted Answer · 2012-09-28 03:21:46Z

1

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

answered Sep 28, 2012 at 3:21

Yann Ramin

33.2k3 gold badges63 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1024858 Over a year ago

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.

Charlie Wu · Accepted Answer · 2012-09-28 03:24:07Z

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, 2012 at 3:24

Charlie Wu

7,7875 gold badges35 silver badges40 bronze badges

2 Comments

user1024858 Over a year ago

I tried, but it still error. Are there any problem?

Charlie Wu Over a year ago

the class.forName bit looked odd to me, try this instead Class.forName("com.mysql.jdbc.Driver");

A N M Bazlur Rahman · Accepted Answer · 2012-09-28 03:34:11Z

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, 2012 at 3:34

A N M Bazlur Rahman

2,3006 gold badges38 silver badges51 bronze badges

3 Comments

user1024858 Over a year ago

Thank you for your help, but it still not work ^_^.

A N M Bazlur Rahman Over a year ago

are you using maven dependency ?

user1024858 Over a year ago

no, i don't use maven. Can you tell me which packet content this driver String driver = "com.mysql.jdbc.Driver"; Thanks!

Kalla · Accepted Answer · 2012-09-28 04:23:27Z

0

add MySQL jdbc driver jar file in to your classpath.

answered Sep 28, 2012 at 4:23

Kalla

1652 silver badges13 bronze badges

1 Comment

user1024858 Over a year ago

It also exist in my classpath <classpathentry kind="lib" path="lib/mysql-connector-java-5.1.6.jar"/>, but still error.

Collectives™ on Stack Overflow

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

4 Answers 4

1 Comment

2 Comments

3 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

3 Comments

1 Comment

Linked

Related