Get mysql and java to work together

Question

I have Eclipse Indigo on Mac Os X and I have downloaded mysql connector (version 5.1).
I have added the jar to the project and I am using this code:

public class Test 
{
    public static void main (String[] args)
    {
        try {
        String url = "jdbc:msql://200.210.220.1:1114/Demo";
        Connection conn = DriverManager.getConnection(url,"","");
        Statement stmt = conn.createStatement();
        ResultSet rs;

        rs = stmt.executeQuery("SELECT Lname FROM Customers WHERE Snum = 2001");
        while ( rs.next() ) {
            String lastName = rs.getString("Lname");
            System.out.println(lastName);
        }
        conn.close();
    } catch (Exception e) {
        System.err.println("Got an exception! ");
        System.err.println(e.getMessage());
    }
    }
}

When I try to execute the program I get this exception:

Got an exception! 
No suitable driver found for jdbc:msql://200.210.220.1:1114/Demo

My question is : how to install the driver? What else should I do?
And once installed the driver, how do I get my database URL (I am using mysql 5.5)?
I haven't found a valid guide on the web, they're all too specific.

This Answer is even better - stackoverflow.com/questions/2839321/… — Stephen C
– Stephen C, Commented May 6, 2012 at 1:06

aleroot · Accepted Answer · 2012-05-06 09:37:32Z

1

Your JDBC connection URL is not correct, refer to the official documentation to check the required format for the URL .

In your case the URL will become :

String url = "jdbc:mysql://200.210.220.1:1114/Demo";

answered May 6, 2012 at 9:37

aleroot

73k32 gold badges182 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

andrew cooke · Accepted Answer · 2012-05-06 01:46:45Z

1

you're missing the "y" in jdbc:mysql

answered May 6, 2012 at 1:46

andrew cooke

47.1k10 gold badges102 silver badges148 bronze badges

1 Comment

Sanath Over a year ago

correct the jdbc connection string and if you have the jdbc jar in your project classpath then it should work properly.

Lena · Accepted Answer · 2012-05-09 06:08:42Z

1

You are using MySQL, the URL should look like this:

jdbc:mysql://200.210.220.1:1114/Demo

may be, review the IP and PORT.

answered May 9, 2012 at 6:08

Lena

552 gold badges2 silver badges9 bronze badges

Comments

Pradeep · Accepted Answer · 2012-05-06 01:59:49Z

0

You may have added the jar to your project but have you also added it to the project classpath? Having the jar exist as a file in your project won't solve the problem. The jar file is clearly not accessible to your program. Right click on your project -> Build Path -> add the jar there.

Database URL looks ok, assuming you have the right host address and port number.

answered May 6, 2012 at 1:59

Pradeep

1981 silver badge9 bronze badges

Collectives™ on Stack Overflow

Get mysql and java to work together

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related