java.sql.SQLException: No suitable driver found for jdbc::mysql://localhost:3306/asd eroor

Question

import java.sql.*;

class Mysqll{
    public static void main(String args[]){
        try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc::mysql://localhost:3306/asd","root","qwerty");
        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery("select * from abc");

        while(rs.next())
        {
            System.out.println(rs.getInt(1) + "   " + rs.getString(2));
        }
        con.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }
}

I am new to jdbc programming. So plese help. Getting this Exception while running the program.

java.sql.SQLException: No suitable driver found for jdbc::mysql://localhost:3306/asd

I had copied mysql-connector.jar file into jre/lib/ext folder. Thanx in advance.

Already visited that ... but didn't found any solution related to my problem — Rajat Goyal, Jul 07 '17 at 13:53
How about if you only put a single colon between `jdbc` and `mysql`? — dcsohl, Jul 07 '17 at 14:30
voting to close: This question was caused by a problem that can no longer be reproduced or a **simple typographical error**. — user85421, Jul 07 '17 at 14:33
Do not put your JDBC driver in the `lib/ext` folder, it is deprecated and will be removed, and can cause version conflicts and other hard to diagnose problems. — Mark Rotteveel, Jul 08 '17 at 07:40

score 0 · Answer 1 · edited Jul 08 '17 at 07:39

0

The connection string being passed to DriverManager is a URL. The formatting matters, and your problem is due to an extra colon between jdbc and mysql (verified by testing on my own system).

Replace jdbc::mysql: with jdbc:mysql:.

edited Jul 08 '17 at 07:39

Mark Rotteveel

100,966
191
140
197

answered Jul 07 '17 at 14:38

dcsohl

7,186
1
26
44

java.sql.SQLException: No suitable driver found for jdbc::mysql://localhost:3306/asd eroor

1 Answers1