JDBC installation problems

[ian rogers]

Hello

I have a problem, which is proberbly very simple but i am still having trouble with it.

I have downloaded the jdbc driver 'mysql-connector-java-3.1.6-bin.jar and placed it in my packages directory. I have changed my classpath to include that directory and the directory containing my java program as below

set classpath=\c:\Program Files\java\jdk1.5.0\mypackages\mysql-connector-java-3.1.6-bin.jar;c:\Program Files\java\jdk1.5.0

when i run my program it comes up with the error "Exception: No Suitable Driver"

I have tried placing the .jar file in the jdk1.5.0\jre\lib\ext but that still comes up with an error.

I was just wondering if anybody can see what i am doing wrong?

I would be very grateful for any advice
Thanks

below is the code for the java program i am using to test my connection:

import java.sql.*;
 
public class connect
{
    public static void main (String []args)
    {
        Connection conn = null;
        String url = "jdbc:mysql://localhost/nightout";
        String userName = "root";
        String password = "friday13";
 
        try 
        {
            Class.forName("com.mysql,jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password);
            System.out.println("Connected");
        }
        catch (Exception e)
              {
                System.err.println ("Cannot connect to server.");
              }
              finally
              {
            if (conn!=null)
            {
              try {
                conn.close();
                System.out.println ("Disconnected.");
                   }
              catch (Exception e) {}
}
}
}
}

[edited to add code tags]
[ February 03, 2005: Message edited by: Jeanne Boyarsky ]

[ian rogers]

Hello again

I have looked into this problem and can see that i the java program was incorrect, and my program now works with JDBC

sorry for this post

Ian

[Jeanne Boyarsky]

Ian,
Welcome to JavaRanch! I'm glad to see that you found the solution so quickly.

I added UBB code tags to your posts. It makes code easier to read. For future reference, the UBB tags are right below the editor on the edit screen.