How to make a MySQL Connection in JAVA

Question

I can't seem to get a connection made on my Java program to java, I have started the MySQL Server, made a database in phpMyAdmin. But I'm confused on how I should use the JDBC Driver that I downloaded from MySQL.

Here's my code:

    private void startConnection()
{
Connection conn = null;
String url = "jdbc:mysql://localhost/";
String dbName = "bank";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "password";
try {
  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection(url+dbName,userName,password);
  System.out.println("Connected to the database");
  conn.close();
  System.out.println("Disconnected from database");
} catch (Exception e) {
    System.out.println("NO CONNECTION =(");
}
}

I had included the jar file in my JDK - jre\lib\ext folder but nothing. Any ideas?

Thanks in advance.

What is the error you get? Code looks good to me. To get the exact error, use e.printStackTrace(); in your catch clause. — ZeissS
– ZeissS, Commented Nov 13, 2010 at 13:23
In your exception handler, please print out the stack trace or at least e.getMessage()! — Carl Smotricz
– Carl Smotricz, Commented Nov 13, 2010 at 13:24
I have put the stacktrace in a paste bin: pastebin.com/gUGy2u1z — Sandeep Bansal
– Sandeep Bansal, Commented Nov 13, 2010 at 13:29
@Sandeep Bansal: Did u included that com.mysql.jdbc.Driver in your Build path — Sankar Ganesh PMP
– Sankar Ganesh PMP, Commented Nov 13, 2010 at 13:32

corriganjc · Accepted Answer · 2010-11-13 13:26:43Z

3

One thing stands out: you haven't specified a network port in the URL. The default port is 3306. So try:

jdbc:mysql://localhost:3306/

For the URL.

answered Nov 13, 2010 at 13:26

corriganjc

7007 silver badges21 bronze badges

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

4 Comments

Sandeep Bansal Over a year ago

tried it with the port number, still didn't work. I have posted the stack trace in the comment above.

corriganjc Over a year ago

2 things: firstly, check that the jar file you have for the MySQL driver is in the classpath or in the jre\lib\ext folder. Secondly, have a peek inside the jar file (with 'jar tf', for example) and check if there is 'com/mysql/jdbc/Driver.class' in there.

corriganjc Over a year ago

Also, if your Java application hasn't been restarted since you added the MySQL driver jar to the class path, you'll need to restart it.

Sandeep Bansal Over a year ago

Although it isn't the full answer, as it was just the case of adding the jar file in the IDE. Yours is the answer more closer so you get it.

Alexis Dufrenoy · Accepted Answer · 2010-11-13 13:27:39Z

1

You have to specify the port. It's String url = "jdbc:mysql://localhost:3306/"; by default.

answered Nov 13, 2010 at 13:27

Alexis Dufrenoy

12k13 gold badges87 silver badges132 bronze badges

Comments

Anthony Raymond · Accepted Answer · 2014-04-30 14:52:26Z

0

private void startConnection()
{
    Connection conn = null;
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "bank";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "password";

    try
    {
        Class.forName(driver).newInstance();
        conn = DriverManager.getConnection(url+dbName,userName,password);
        System.out.println("Connected to the database");
        conn.close();
        System.out.println("Disconnected from database");

    }
    catch (Exception e)
    {
        System.out.println("NO CONNECTION =(");
    }
}

This will work

edited Apr 30, 2014 at 14:52

Anthony Raymond

7,8626 gold badges47 silver badges63 bronze badges

answered May 2, 2013 at 11:32

CodeMadness

14 bronze badges

Collectives™ on Stack Overflow

How to make a MySQL Connection in JAVA

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related