I am trying to use
JDBC with MySQL. I�m a total novice as far as JDBC is concerned so apologies if my errors are glaringly obvious, but I�m not finding the instructions on Java�s sun site and the MYSQL site, not very helpful.
I have successfully installed and tested MYSQL on my PC and am running JRE and JDK 6.
I have downloaded the JDBC driver from MYSQL and added a classpath to the environment variables �C:\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5-bin.jar� which points to the necessary file as per the My SQL instructions.
I have then been instructed to compile a
java program that loads the drivers.
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();
System.out.println("Driver Loaded");
}
catch (Exception ex)
{
System.out.println("Failure");
}
}
}
I have compiled this file in a folder Desktop\Myjava. When I run it from the command line it just says �Exception in
thread �main� java.lang.NoClassDefFoundError: LoadDriver.
Any instructions on how to get my JDBC drivers working, much appreciated.