I want to connect my java web application with mysql database but getting error

Question

Driver Not Foundjava.lang.ClassNotFoundException: com.mysql.jdbc.driver

I want to make connection between my java web application and mysql database through XAMP. I also have added external jar file which is mysql-connector-java-6.0.2.jar but still i am getting this error.

I have done this code.

public static void main(String[] args) 
{
    try {
        Class.forName("com.mysql.jdbc.driver");
        System.out.println("Driver has been found..");
    } catch (ClassNotFoundException ex) {
        System.out.println("Driver Not Found"+ex);
    }

    String url="jdbc:mysql://localhost/hms";
    String user="root";
    String password="";

    Connection con=null;

    try {
        con=DriverManager.getConnection(url, user, password);
        System.out.println("Driver is successfully loaded.");
    } catch (SQLException ex) {
        System.out.println("Something is not good.");
    }
}

Possible duplicate of Connect Java to a MySQL database

Mark Rotteveel
– Mark Rotteveel

2016-07-30 10:41:28 +00:00
Commented Jul 30, 2016 at 10:41 — Mark Rotteveel
– Mark Rotteveel, Commented Jul 30, 2016 at 10:41

Mureinik · Accepted Answer · 2019-04-05 14:45:21Z

3

Class names in Java are case-sensitive. You need to capitalize the "D" in "driver":

Class.forName("com.mysql.jdbc.Driver");
// Here ----------------------^

edited Apr 5, 2019 at 14:45

answered Jul 30, 2016 at 8:09

Mureinik

316k54 gold badges399 silver badges405 bronze badges

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

Comments

Jahid Mahmud · Accepted Answer · 2016-07-30 08:24:09Z

2

You should write this because because java is Case-Sensitive

public static void main(String[] args) 
{
    try {
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("Driver has been found..");
    } catch (ClassNotFoundException ex) {
        System.out.println("Driver Not Found"+ex);
    }

    String url="jdbc:mysql://localhost/hms";
    String user="root";
    String password="";

    Connection con=null;

    try {
        con=DriverManager.getConnection(url, user, password);
        System.out.println("Driver is successfully loaded.");
    } catch (SQLException ex) {
        System.out.println("Something is not good.");
    }
}

answered Jul 30, 2016 at 8:24

Jahid Mahmud

1,1361 gold badge12 silver badges34 bronze badges

Collectives™ on Stack Overflow

I want to connect my java web application with mysql database but getting error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related