No suitable driver found for jdbc:mysql://localhost:3306/egov

Question

i work on project using intellij idea 15, so when i'm trying to connect to data base i got this error

No suitable driver found for jdbc:mysql://localhost:3306/egov

this is my datasource file

public class DataSource {

private String url;
private String login;
private String password;
private Connection connection;
private Properties properties;
private static DataSource instance;

private DataSource() {
    try {
        properties = new Properties();
        properties.load(new FileInputStream(new File("configuration.properties")));
        url = properties.getProperty("url");
        login = properties.getProperty("login");
        password = properties.getProperty("password");
        connection = DriverManager.getConnection(url, login, password);
    } catch (SQLException | IOException ex) {
        System.out.println(ex.getMessage());
    }
}
public Connection getConnection() {
    return connection;
}
public static DataSource getInstance() {
    if (instance == null) {
        instance = new DataSource();
    }
    return instance;
}
}

and this is the configuration.properties file

url=jdbc:mysql://localhost:3306/egov
login=root
password=

and also i add the jar file mysql-connector-java any one know how to fix this problem

And have you added the MySQL JDBC driver to your classpath? Are you using Maven? — Tunaki, Mar 11 '16 at 21:05

score 2 · Accepted Answer · answered Mar 11 '16 at 21:10

You need to load the db driver files via the IDEA GUI. Go to your View menu, and select Database from the Tool Window submenu. In the Database window click the "wrench" icon in the toolbar at the top, to open up the Data Sources and Drivers window. If you don't have a MySQL data source listed under Project Data Sources, click the + button at the top left to add it, otherwise just click on the "MySQL" line under Project Data Sources. Look near the bottom of the window for a link that says "Download missing driver files", and click it to install the necessary drivers into IDEA.

This still tells me "No suitable driver found." – Jaap Weijland Mar 24 '18 at 19:05 — Jaap Weijland, Mar 24 '18 at 19:05

score 1 · Answer 2 · answered Mar 11 '16 at 21:15

1

Amine Harbaoui, did you try this?

login = properties.getProperty("login");
    password = properties.getProperty("password");

     Class.forName("com.mysql.jdbc.Driver");// include this line in your code.

    connection = DriverManager.getConnection(url, login, password);
} catch (SQLException | IOException ex) {

answered Mar 11 '16 at 21:15

ffSouza

93
8

i fix it , the problem is with the jar file , thank you – Amine Harbaoui Mar 11 '16 at 21:21
ok, it's good! @AmineHarbaoui – ffSouza Mar 11 '16 at 21:25
What was your problem exactly, Amine? After an hour of searching this solution worked for my, but I don't get why I have to do this. – Jaap Weijland Mar 24 '18 at 19:07

No suitable driver found for jdbc:mysql://localhost:3306/egov

2 Answers2