Clear Filters
Clear Filters

java.sql.SQLException: No suitable driver found for dbc:mysql://localhost

71 views (last 30 days)
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

Answers (2)

Deborah
Deborah on 9 Aug 2011
Follow-up: just checked my old notes. I had to copy mysql-connector-java-5.1.14-bin.jar to MATLAB_JAVA/jre/lib/ext to get this to work!
  2 Comments
Ali Esmaili
Ali Esmaili on 7 May 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.

Sign in to comment.


line hammer
line hammer on 21 Jun 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.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!