This code shows the error of: "No suitable Driver found for jdbc:mysql://localhost:3306/ab"

Question

import java.sql.SQLException;  
import java.sql.Statement;  
import java.sql.Connection;  
import java.sql.DriverManager;  
import javax.swing.JOptionPane;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
String a=t1.getText();  
{try {  
    String driver = "com.mysql.jdbc.Driver";  
Class.forName(driver);  
Connection C=DriverManager.getConnection("jdbc:mysql://localhost:3306/ab","root","root");  
Statement S=C.createStatement();  
String query="Insert into ab values('"+a+"');";  
S.executeUpdate(query);  
}  
catch (Exception e)  
{  
    JOptionPane.showMessageDialog(this, e.getMessage());  
}     }  
    }

I have given the correct address but it is showing the no driver found.I'm using the mysql-connector-C-6.1. It is in my build path. I have restarted MySQL. I've also logged on from the command line with root and Password and it connected fine. I'm not currently seeing a port 3306 in STATUS.

Connector/C is for C, not for Java. Having things on your build path is not directly relevant: the driver needs to be on the runtime classpath. — Mark Rotteveel, Mar 31 '17 at 09:20

score 0 · Answer 1 · answered Mar 30 '17 at 18:43

0

Are you sure you are using the connector-c? That one is, as the name suggests, for the C language and not for java. You should be using the connector-j library.

answered Mar 30 '17 at 18:43

Jiří

13
4

I used connector-j library this time. But again it is showing the same error. – Mayank Jindal Mar 31 '17 at 06:11

This code shows the error of: "No suitable Driver found for jdbc:mysql://localhost:3306/ab"

1 Answers1