Problem with loading driver

[b01g]

Hello,
Trying to load Connector/J driver for accesing MySQL server. JDBC
# import java.sql.Connection;
# import java.sql.DriverManager;
# import java.sql.SQLException;
#
# public class LoadDriver {
# public static void main(String[] args) {
# try {
#
# Class.forName("com.mysql.jdbc.Driver").newInstance ();
# } catch (Exception ex) {
# ex.printStackTrace();
# }
# }
# }


i get this error :

Exception in thread "main" java.lang.NoClassDefFoundError: LoadDriver
Caused by: java.lang.ClassNotFoundException: LoadDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 07)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 48)
Could not find the main class: LoadDriver. Program will exit.

I already created a environment variable named CLASSPATH and give it value = C:\mysql-connector-java-5.1.14\mysql-connector-java-5.1.14-bin.jar.
What can be the problem. Please help. Thnx in advance.

[Tolls]

It's not the mysql it can't find.
It's your LoadDriver class it can't find.

How are you executing this, in what directory, and where is the LoadDriver.class file?

[b01g]

I keep my LoadDriver.java file in C:\Java\src.
I can't figure out what value should i put in CLASSPATH - the folder location of conncetor/j or the jar file? Should I put the class that i created in that folder too? I'am totaly wracked. Please don't leave me without an answer. I had been on this since yesterday and without results. Thnx in advance for your patience.

[Petr]

Hi,
You have mistake in classpath. You can run the class as follows.
src/LoadDriver.java
src/mysql-connector-java-5.1.8-bin.jar

javac LoadDriver.java
java -cp mysql-connector-java-5.1.8-bin.jar: LoadDriver

[b01g]

The same thing:(

[goldest]

OK. Let's say your code file LoadDriver.java is in the directory C:\Java\src

You can navigate from the command prompt to that directory and use the javac to compile the java file. Up to here, the things must work fine.

C:\Java\src>javac LoadDriver.java

After running above command, the LoadDriver.class file would get generated at the same location.

Now, suppose that the jar file that contains your mysql driver, is in the C:\Java\lib directory. Now, while running your program, you need to make sure that your compiler will see both the .class files, the one generated above and the one which is inside the jar file.

For this purpose, you need to use the -cp option of the java command. By using this, you can provide the class path where compiler will search for the .class files required.

So, try following command,

C:\Java\src>java -cp C:\Java\lib\mysql-connector-java-5.1.8-bin.jar;. LoadDriver

See the class path above carefully. The portion before the semicolon (;) gives the full path to the jar file and portion after it, which is a dot (.), tells the compiler to look into the current directory for class files.

Keep it in mind that, when you are referring to the jar file that contains the required class files, always mention the .jar file name in the command and not the directory path till that jar file.

Hope that helps,

Goldest

[goldest]

In case if you are interested to know more about java and javac command line options, refer to below links.

For java: java

For javac: javac

Hope that helps,

Goldest

[yazen]

In case if you are interested to know more about java and javac command line options, refer to below links.

For java: java

For javac: javac

Hope that helps,

Goldest

Your answer is very much appreciated Mr. Goldest.


I finally was able to run my sample without errors.

Got the answer I was looking for.