java.sql.SQLNonTransientConnectionException Cannot load connection class because of underlying exception

Question

New to JDBC and trying to connect to data base in MySql workbench. Following is the Java code

import java.sql.*;


public class Demo {
    
    public static void main(String[] args) throws Exception
    {   
        String url = "jdbc:mysql://localhost:3306//students?useSSL=false"; 
        String user = "root";
        String password = "root";
        String query = "Select * from students";
        
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection con = DriverManager.getConnection(url, user, password);  
        Statement st = con.createStatement();
        ResultSet rt = st.executeQuery(query);
        
        rt.next();
        String name = rt.getString("stu_name");
        
        System.out.println(name);
        
        st.close();
        con.close();
    }

}

Following is the error being thrown:

Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the main URL sections.

My MySQL workbench version is 8.0.21 with same version for mysql-connector/J Database in workbench

Malformed database URL. Remove the second double slash and try again. — Lothar
– Lothar, Commented Aug 24, 2020 at 9:59

martinspielmann · Accepted Answer · 2020-08-24 09:59:02Z

2

I assume the problem is the double slash (//) in your URL. Try

 String url = "jdbc:mysql://localhost:3306/students?useSSL=false";

instead.

answered Aug 24, 2020 at 9:59

martinspielmann

6061 gold badge8 silver badges22 bronze badges

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

1 Comment

Varun Sharma Over a year ago

ya, just figured that out 😅, thanks for your help 👍

Collectives™ on Stack Overflow

java.sql.SQLNonTransientConnectionException Cannot load connection class because of underlying exception

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related