java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]

Question

I have this Java program: MySQLConnectExample.java

import java.sql.*; import java.util.Properties;  public class MySQLConnectExample {     public static void main(String[] args) {         Connection conn1 = null;         Connection conn2 = null;         Connection conn3 = null;          try {             String url1 = "jdbc:mysql://localhost:3306/aavikme";             String user = "root";             String password = "aa";              conn1 = DriverManager.getConnection(url1, user, password);             if (conn1 != null)                 System.out.println("Connected to the database test1");              String url2 = "jdbc:mysql://localhost:3306/aavikme?user=root&password=aa";             conn2 = DriverManager.getConnection(url2);             if (conn2 != null) {                 System.out.println("Connected to the database test2");             }              String url3 = "jdbc:mysql://localhost:3306/aavikme";             Properties info = new Properties();             info.put("user", "root");             info.put("password", "aa");              conn3 = DriverManager.getConnection(url3, info);             if (conn3 != null) {                 System.out.println("Connected to the database test3");             }         } catch (SQLException ex) {             System.out.println("An error occurred. Maybe user/password is invalid");             ex.printStackTrace();         }     } } 

I compile it like this:

E:\java mysql code driver>javac MySQLConnectExample.java  E:\java mysql code driver>java -cp mysql-connector-java-3.0.11-stable-bin.jar;. MySQLConnectExample 

I get this error:

An error occurred. Maybe user/password is invalid java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/ aavikme         at java.sql.DriverManager.getConnection(DriverManager.java:596)         at java.sql.DriverManager.getConnection(DriverManager.java:215)         at MySQLConnectExample.main(MySQLConnectExample.java:20) 

What am I doing wrong?

Answer 1

Make sure you run this first:

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

This forces the driver to register itself, so that Java knows how to handle those database connection strings.

For more information, see the MySQL Connector reference.