Connecting to MySQL Database from java in IDE Netbeans

Question

So this is my thing. I am trying to connect do MySQL Database from java. I have downloaded connector driver from MySQL ( Its called "mysql-connector-java-5.0.8-bin.jar" ) and I added to my libraries (Im using NetBeans). I tried to do simple connection like this:

package datacon;

public class Datacon {

    public static void main(String[] args) {

        try {

            java.sql.Connection con = (java.sql.Connection) java.sql.DriverManager
                .getConnection("jdbc:mysql://localhost:3306/test"
                /*, "root"
                  , "root" */ );

        } catch ( Exception e ) {
            System.out.println( e.toString() );
        }
    }
}

But this hapened:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test

I made my research on the internet and this pretty common thing, but none of the answers helped me. I was able connect to database through NetBeans/services, so that URL jdbc:mysql://localhost:3306/test should be correct.

I am using:

java:   Oracle java SDK 1.7.0 _ 45
IDE:    NetBeans 7.4
OS:     Debian 3.2.51-1 x86_64
Driver: MySQL Connector/J 5.0.8

I am afraid this is gonna have a very trivial answer, but I am stuck here for a while now and i need to move. So what am I missing?

Paul Vargas · Accepted Answer · 2013-11-28 13:33:26Z

1

Add:

static {
    try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (final ClassNotFoundException e) {
        e.printStackTrace();
    }
}

answered Nov 28, 2013 at 13:33

Paul Vargas

42.2k16 gold badges108 silver badges148 bronze badges

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

1 Comment

Joop Eggen Over a year ago

Static not needed. As explanation: the driver class is loaded this way so one need not import a specific db provider, and also the API cannot be extended with specific provider functionality.

KhAn SaAb · Accepted Answer · 2013-11-28 19:09:54Z

1

I thing you forget to load driver .

Class.forName("com.mysql.jdbc.Driver");

and make sure you have mysql-connector-java-5.1.22-bin in your class path.

edited Nov 28, 2013 at 19:09

answered Nov 28, 2013 at 13:39

KhAn SaAb

5,4166 gold badges34 silver badges55 bronze badges

Comments

Tatarao voleti · Accepted Answer · 2013-11-28 13:44:59Z

0

try {
      Class.forName("org.gjt.mm.mysql.Driver");
      Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
    } catch(ClassNotFoundException e) {
        e.printStackTrace();
    }

answered Nov 28, 2013 at 13:44

Tatarao voleti

5133 gold badges8 silver badges23 bronze badges

Comments

user3441712 · Accepted Answer · 2014-03-20 11:16:49Z

0

try { class.forname("com.mysql.jdbc.Driver");

     driver.getconnection("connenctionurl","name","password");

            Statement s =goodrecive.asif().createStatement();
            s.executeUpdate("INSERT INTO product(productno,productname,quantity,ammount)values('"+t1.getText()+"','"+t2.getText()+"','"+t3.getText()+"','"+t4.getText()+"')");

    } catch (Exception e) {
        System.out.println(e);
    }
}

answered Mar 20, 2014 at 11:16

user3441712

1

Comments

Tiago NET · Accepted Answer · 2016-10-27 17:05:07Z

0

My class for connection:

package connection;

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

public class ConnectionFactory {  
    public Connection getConnection() throws SQLException {
        return DriverManager.getConnection("jdbc:mysql://localhost:3306/<database>", "<user>", "<password>");
    }        
}

Don't need add ClassForName. This is necessary in older versions of java.

answered Oct 27, 2016 at 17:05

Tiago NET

1539 bronze badges

Collectives™ on Stack Overflow

Connecting to MySQL Database from java in IDE Netbeans

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related