JDBC warning message: "..... The new driver class is `com.mysql​.cj.jdbc.D​river'....​"

136 次查看（过去 30 天）
Simon
Simon 2022-8-19
评论： Simon 2023-11-17
I have configured a JDBC data source successfully. There is no problem of reading in a database from the data source.
However, when I was doing
testConnection(opts,username,password)
I received a warning message
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
According to what I google for a possible explanation, it seems that Oracle has changed the name of the driver class. There is a good explanation offered at Stackoverflow. The warning message is just a warning, and I can still successfully connect with the MySQL server. I was just wondering whether Matlab should update the driver class name accordingly in its codes.

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

采纳的回答

Dinesh
Dinesh 2023-11-17
Hi Simon.
It is possible to remove the warning message that you are facing by specifying the name of driver class by yourself. The following code will give you an idea:
% Create the database connection object using the updated driver class
conn = database('dbname', 'username', 'password', 'com.mysql.cj.jdbc.Driver', 'jdbc:mysql://localhost:3306/dbname');
Please refer the following link:
https://www.mathworks.com/help/database/ug/database.html
The developers are aware of these deprecations and the code will be updated eventually.

更多回答（0 个）

类别

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

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by