Cannot find JDBC driver

Question

try
        {
            String userName = "root";
            String password = "";
            //<facility> is my database
            String url = "jdbc:mysql://localhost/facility";
            Class.forName ("com.mysql.jdbc.Driver").newInstance ();
            conn = DriverManager.getConnection (url, userName, password);
            System.out.println ("Database connection established");
        }
        catch (Exception e)
        {
            System.out.println ("Cannot connect to database server " +e.getClass().getName());

        }

output> Cannot connect to database server java.lang.ClassNotFoundException

Answer 1

To use the MYSQL Driver (Connector/J) you will need to download it from MySQL Connectors and put it in your classpath.

Answer 2

Download the jdbc-mysql driver here.

Include it in your classpath.

Answer 3

It seems that you should put your MySQL driver jar into your classpath.