MySQL Beginner Has Problem With Loading JDBC Driver

[JiaPei Jen]

Hi, I am having problem with loading JDBC driver, and need your diagnotic help.
1. I have installed MySQL (C:\mysql), created a databse (soup), and created a little table (VIDEOS). I am able to see the table in the console:
sql>select * from videos
2. I have downloaded the latest version of Connector/J (mysql-connector-java-3.1.0-alpha.zip), and unzip the zip file into my C:\ directory.
3. I copied the mysql-connector-java-3.1.0-alpha-bin.jar to the C:\j2sdk1.4.1_02\jre\lib\ext folder and it is in my CLASSPATH
4. MySQL server is running
C:\> C:\mysql\bin\mysqld-nt --standalone
5. open another DOS window and use the database
mysql>USE SOUP
6. succesfully compiled a Java program (javac Test.java):

import java.sql.* ;
public class Test
{
    public static void main( String[] args )
    {
        try
        {
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            try
            {
                Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/soup" );
                try
                {
                    Statement statement = con.createStatement();
                    ResultSet rs = statement.executeQuery("SELECT TITLE FROM VIDEOS");
                    while ( rs.next() )
                    {
                        System.out.println( rs.getString( "TITLE" ) );
                    }
                    rs.close();
                    statement.close();
                }
                catch ( SQLException e )
                {
                    System.out.println( "JDBC error: " + e );
                }
                finally
                {
                    con.close();
                }
            }
            catch( SQLException e )
            {
                System.out.println( "could not get JDBC connection: " + e );
            }
        }
        catch( Exception e )
        {
            System.out.println( "could not load JDBC driver: " + e );
        }
    }
}

7. when I run the Java program (java Test), I got
the message:
could not load JDBC driver: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
What am I missing?
[ March 21, 2003: Message edited by: JiaPei Jen ]
[ March 21, 2003: Message edited by: JiaPei Jen ]
[ March 21, 2003: Message edited by: JiaPei Jen ]

[Dirk Schreckmann]

Perhaps something is different or wrong with the alpha JConnector driver you're using. What happens when using the stable version 3.0.6?
Also, how are you running the app? From the command line or through an IDE? and which IDE?

[Gregg Bolinger]

org.gjt.mm.mysql.Driver is for the old mm.MySQL Driver that has now become Connector/J.
Try using com.mysql.jdbc.Driver instead.