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

61 次查看（过去 30 天）
Deborah
Deborah 2011-8-9
回答： line hammer 2021-6-21
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

请先登录，再回答此问题。

回答（2 个）

Deborah
Deborah 2011-8-9
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 个评论
Ali Esmaili
Ali Esmaili 2020-5-7
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
line hammer 2021-6-21
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.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by