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

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.

Answer 1

[Dinesh]

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.

[Simon]

Thanks for your answer. Because native connector works after Matlab updates, I have switched to it.