connecting to mysql, with java, on a mac

[paulio macmurray]

Hi all,

Im very puzzled.

I have a mac, and im trying to connect to mysql on localhost with java, however, it wont, and ive been good and followed the rules, but it wont work :-(

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MySql {

  public static void main(String args[]) throws Exception
  {
    Connection con = null;

    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      con = DriverManager.getConnection("jdbc:mysql://localhost/",
        "root", "root");

      if(!con.isClosed())
        System.out.println("Successfully connected to " +
          "MySQL server using TCP/IP...");

    } catch(Exception e) {
      System.err.println("Exception: " + e.getMessage());
    } finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
    }
  }
}

[Jeanne Boyarsky]

Paulio,
Welcome to JavaRanch!

What error message does the program give you?

[paulio macmurray]

Hi,

Thanks for the response.

the error shown is :Exception: com.mysql.jdbc.Driver

i also made a slightly different script which is below. The error message in that is my own "Cannot connect to database"

import java.sql.*;

   public class Connect
   {
       public static void main (String[] args)
       {
           Connection conn = null;

           try
           {
               String userName = "whitep8";
               String password = "whitep8";
               String url = "jdbc:mysql://localhost:3306/test/";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
               System.out.println ("Database connection established");
           }
           catch (Exception e)
           {
               System.err.println ("Cannot connect to database server");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
       }
   }

[Bear Bibeault]

Most likely the drive isn't in the classpath.

[Vijitha Kumara]

paulio macmurray wrote:the error shown is :Exception: com.mysql.jdbc.Driver
i also made a slightly different script which is below. The error message in that is my own "Cannot connect to database"

Just print the exact error you are getting by printing it (ie: e.printStackTrace()) inside the catch block and post that error here? You have the JDBC Driver in your classpath?

[paulio macmurray]

Hi All,

Thanks for the posts.

Im also convinced that the issue is with the class path.

I have tried the following in the mac terminal:

java -cp /users/paulwhite/NetBeansProjects/bin/drivername.jar

but to no avail

Can you offer any advice as to how i can do this?

[Vijitha Kumara]

paulio macmurray wrote:I have tried the following in the mac terminal:
java -cp /users/paulwhite/NetBeansProjects/bin/drivername.jar

Is this the exact command you tried? Then what was the output? BTW, Did you try printing the stack trace?

[paulio macmurray]

Hi All,

Just a note to let you know i managed to get the script to work, but only by dumping the connection file in the same directory as the java file, and then javac ing it in a command prompt.

Is there anyway to avoid this in netbeans?

PHEW!!!

[Vijitha Kumara]

paulio macmurray wrote:Just a note to let you know i managed to get the script to work, but only by dumping the connection file in the same directory as the java file, and then javac ing it in a command prompt.

If you set the classpath properly (which should includes the required jar files and the class files you are executing) no need to have them in the same place.

Is there anyway to avoid this in netbeans?

To run this inside the IDE you should set those jars in the build path of the IDE.