java.sql.SQLException: No suitable driver found for dbc:mysql://localhost
26 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I'm getting the error: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost
I have mysql-connector-java-5.1.14-bin.jar in my javaclasspath. I'm using the following code:
>> url = java.lang.String(['jdbc:mysql://localhost:3306']); >> db_conn = DriverManager.getConnection (url); ??? Java exception occurred: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
This worked for me previously, but not anymore! Anybody have any ideas? Thanks much Debbie
0 commentaires
Réponses (2)
Deborah
le 9 Août 2011
2 commentaires
Ali Esmaili
le 7 Mai 2020
I have done this on Matlab 2019b and it is not working. I am able to add the data source into the javaaddpath but it has no effect.
line hammer
le 21 Juin 2021
The reason you got this error is because you forgot to register your java mysql jdbc driver with the application.
Should be like this:
Class.forName("com.mysql.jdbc.Driver");
This forces the driver to register itself, so that Java knows how to handle those database connection strings.
You'll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName("...") parameter.
0 commentaires
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!