JDBC Exception

[SankalpHP]

sir I had write this simple code to connect to database using JDBC , Also download a JDBC MySQL connector jar file & also set a class path of it in my eclipse project but when I run a program it shows me a Exception
"Exception in thread "main" java.sql.SQLException: No suitable driver found for jdc:mysql://localhost:3306/school"

Code

package connection;

//Steps
// 1 import
// 2 load and register
// 3 create the statement
// 4 execute the query
// 5 process the query
// 7 close

import java.sql.*;
public class JDBC {

	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdc:mysql://localhost:3306/school", "root", "Password");
		
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("Select *from school where studentId = 1");
		
		rs.next();
		int studentId = rs.getInt("studentId");
		String studentName = rs.getString("studentId");
		String studentGrade = rs.getString("studentGrade");
		String studentResult = rs.getString("studentResult");
		
		System.out.println(studentId +" "+ studentName +" "+ studentGrade +" "+ studentResult);
		
		st.close();
		con.close();
		
		
		

	}

}

```java

![Discussion](https://user-images.githubusercontent.com/97338370/169515856-06763bb1-6bf1-4565-a886-e12fc5064f78.PNG)

[akash-coded]

It is difficult to provide a resolution without having a look at your setup or project configuration. Make sure you have downloaded the MySQL Connector corresponding to your MySQL Server. @SankalpHP

[SankalpHP]

sir I have MySQL version 8.0.27 and download a Mysql connector of version "mysql-connector-java-8.0.29"

[akash-coded]

There is a mismatch in the version of the connector and server. Please paste some screenshots of your "referenced libraries" in Eclipse