Error getting connection with MySQL connector

Question

The error:

No suitable driver found for jdbc:mysql://localhost:3306
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

And here is my code.

public Connection getConnection() throws SQLException {
        Connection conn;
        Properties connectionProps = new Properties();
        connectionProps.put("user", "root");
        connectionProps.put("password", "pass");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" , connectionProps);
        System.out.println("Connected to database");
        return conn;

    }

What does the documentation state about drivers? What have you tried? — greybeard
– greybeard, Commented Dec 11, 2016 at 16:48

eli-k · Accepted Answer · 2016-12-11 09:15:56Z

1

did you import it? import java.sql.*; try putting in the top of class. Also put this Class.forName("com.mysql.jdbc.Driver"); in before the DriverManager.getconnection for class to identify the driver.

edited Dec 11, 2016 at 9:15

eli-k

11.5k12 gold badges46 silver badges48 bronze badges

answered Dec 11, 2016 at 8:28

Jesus Enrique Buencamino

223 bronze badges

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

1 Comment

Bayarjargal Jargalsaikhan Over a year ago

Oh thank you , sir. I added Class.forName("com.mysql.jdbc.Driver"); before getConnection method and it works . Thank you again.

Matteo Baldi · Accepted Answer · 2016-12-11 08:31:26Z

1

You need to register your driver before getting connection (if it's already registered, nothing will be done):

public Connection getConnection() throws SQLException {
        String myDriver = "com.mysql.jdbc.Driver";
        String myUrl = "jdbc:mysql://localhost:3306/";
        Class.forName(myDriver);
        Connection conn;
        Properties connectionProps = new Properties();
        connectionProps.put("user", "root");
        connectionProps.put("password", "pass");
        conn = DriverManager.getConnection(myUrl , connectionProps);
        System.out.println("Connected to database");
        return conn;
}

answered Dec 11, 2016 at 8:31

Matteo Baldi

5,83811 gold badges44 silver badges54 bronze badges

Collectives™ on Stack Overflow

Error getting connection with MySQL connector

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related