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

Question

Simon 2022-8-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1781950-jdbc-warning-message-the-new-driver-class-is-com-mysql-cj-jdbc-driver

评论： Simon 2023-11-17

采纳的回答： Dinesh

在 MATLAB Online 中打开

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Dinesh 2023-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1781950-jdbc-warning-message-the-new-driver-class-is-com-mysql-cj-jdbc-driver#answer_1354712

在 MATLAB Online 中打开

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.