Problem with com.mysql.jdbc.Driver driver

[Shantanu Deshmukh]

Hi,

I am trying to create simple JDBC program to access mysql database.
This is the code.

import java.sql.*;
public class accessMySQL
{
    public static void main(String[] args)
    {
	Connection con = null;
	try
	{
	    String username = "aaa_user";
	    String password = "xxxxx";
	    String url = "10.10.133.186";
	    Class.forName("com.mysql.jdbc.Driver").newInstance();
	    con = DriverManager.getConnection(url,username,password);
	    System.out.println("Connection Established!");
	}
	catch(Exception e)
	{
	    System.out.println("There was some error while establishing connection to the database"+e);
	}
	finally
	{
	    try
	    {
		con.close();
		System.out.println("Connection Successfully Closed.");
	    }
	    catch(Exception e)
	    {
		System.out.println("There was some error while closing connection to the database");
	    }
	}
    }
}

This gives me java.lang.ClassNotFoundException: com.mysql.jdbc.Driver error.
Please help !!

Shantanu

[Arun Kumarr]

is your mysql jar in classpath?

[Shantanu Deshmukh]

I m sorry if I may sound childish for a Java Programmer, but do we need a separate mysql jar ? If so, where to get it from ?

[Sumit Bisht]

Yes, you'll need to download the mysql connector for java (mysql jdbc driver)

[Shantanu Deshmukh]

ok, I have downloaded MySQL connector 5.0.8. I have saved it in /home/shantanu
I am giving this command javac -cp /home/shantanu/mysql-connector-java-5.0.8-bin.jar accessMySQL.java

It compiles with no errors, but when run it, it gives my same error of com.mysql.jdbc.Driver classNotFoundException

[Vijay Tidake]

HI,

Also at runtime you need to specify the classpath of the jar file

Thanks.

[Shantanu Deshmukh]

I hit this command

java -cp /home/shantanu/mysql-connector-java-5.0.8-bin.jar accessMySQL

and now it give me class not found exception java.lang.ClassNotFoundException: accessMySQL

help !!

[Vijay Tidake]

Hi,

try this one ,"." to add your current directory to classpath in which class accessMySQL exist

java -cp /home/shantanu/mysql-connector-java-5.0.8-bin.jar; . accessMySQL

Hope this helps
Thanks

[Shantanu Deshmukh]

i wrote the exact command you gave me, but then all options related to java command were shown, meaning it was not a correct command or did not have correct options.

sorry for bugging, but more help needed. I am on this since the whole day, but cant get it to work !!

[Steven Bruton]

Firstly, you do not need to specify the classpath for compiling.

To run try the following;

Enter full class path of jar
java -cp C:\folder\folder\connector.jar;. ClassName

If there is any white space in the path surround with quotes
java -cp "C:\folder\folder with spaces\connector.jar";. ClassName

Try entering the full path of both the jar and the class file (once again you may need quotes if white spaces in path)
java -cp C:\folder\folder\connector.jar;C:\folder\folder\src ClassName

[sudharsan ponnusamy]

very same problem i found in netbeans but after including mysql library files the problem gets over

[Shantanu Deshmukh]

I m doing everything you folks are telling me. I entered this command while compiling
javac accessMySQL.java

compiled with no errors.

While running:
java -cp /home/shantanu/DEV_DOCS/SOAP/mysql-connector-java-5.0.8-bin.jar;. acessMySQL

I am showing full list of java options !!! why isn't this working ???

[Vijitha Kumara]

I am showing full list of java options !!! why isn't this working ???

In Linux variants you have to use colon (:) instead semi-colon as the path separator.

Try:
java -cp /home/shantanu/DEV_DOCS/SOAP/mysql-connector-java-5.0.8-bin.jar:. acessMySQL

[Shantanu Deshmukh]

Hey vijay, thanks for that hint.
But now I am getting class not found exception !! the path I just gave is the same path where my class file lies. What else could I be missing.
I understand now, that the basics like classpath, java_home are not that clear to me. please help me if I am wrong with them, in this case.
(I really want to learn java, lest I clear these obstacles )

[Vijitha Kumara]

But now I am getting class not found exception...

Can you show us the exact error message you get?

[Shantanu Deshmukh]

this is the command
java -cp /home/shantanu/DEV_DOCS/SOAP/mysql-connector-java-5.0.8-bin.jar:. acessMySQL

this is the error:

Exception in thread "main" java.lang.NoClassDefFoundError: acessMySQL
Caused by: java.lang.ClassNotFoundException: acessMySQL
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:334)
Could not find the main class: acessMySQL. Program will exit.

[Shantanu Deshmukh]

I am also trying on eclipse. There I get No suitable driver found for the same program. i have imported external JAR, that mysql connector one. no luck there either.
by the way is this url format wrong ?

con = DriverManager.getConnection(url,username,password);

[Vijitha Kumara]

Where's your acessMySQL.class file is located? If it's not inside the current directory then you have to add a entry to -cp switch to point to that location.

[Shantanu Deshmukh]

hi all, thanks for your input.
The connection URL was wrong in the program. I also had not included com folder provided with the connector. This all is working in Eclipse now.
Still not much clue how to run it all on command prompt.

[Vijitha Kumara]

Still not much clue how to run it all on command prompt.

You have to set the classes/jar files required properly to run it. That's it. Check whether you have them (driver jar you probably have this already, and the class file you trying to run) in the mentioned -cp entries.