Connecting to a remote mysql database

[john flowers]

hi all,
I have tried using this code to access a mysql database but alas i get an error 'Exception in thread "main" java.sql.SQLException: No sutible driver'
but I installed the driver from 'http://mmmysql.sourceforge.net/' and set the CLASSPATH up correctly!?
Here is the code
--------------------------------------------------------
import java.sql.*;
public class Connect{
public static void main(String args[]) throws Exception{
Connection con = null;
try{
String url = "jdbc://hostname:3306/database";
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection(url, "uname", "pwd");
if(con != null){
System.out.println("whehe");
}
}
finally{
if(con != null){
try{
con.close();
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}
}
}

[Joe Ess]

Just trying to rule out the obvious. In the following string:

 String url = "jdbc://hostname:3306/database";

You replace "hostname" with the host name of the computer the database resides on and "database" with the name of the database you are attempting to open, right?

[Wayne L Johnson]

URL should be:
String url = "jdbc:mysql://hostname:3306/database";
making sure you do what Joe suggested in terms of the hostname and database.

[john flowers]

No thats all sorted, its the error message with the driver thats the prob.
thanx anyway,
j.f.

[Lu Battist]

Print out the classpath variable and ensure it has the mysql-connector-java~WhateverItsNameIs.jar.