java.sql.SQLException: No suitable driver found for dbc:mysql://localhost
显示 更早的评论
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
2011-8-9
1 个投票
2 个评论
Chirag Gupta
2011-8-9
You can also just do a javaaddpath('location of sqlconnector.jar')
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
2021-6-21
0 个投票
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.
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2021-6-21
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
