Clear Filters
Clear Filters

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

155 views (last 30 days)
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.

Accepted Answer

Dinesh
Dinesh on 17 Nov 2023
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:
The developers are aware of these deprecations and the code will be updated eventually.
  1 Comment
Simon
Simon on 17 Nov 2023
Thanks for your answer. Because native connector works after Matlab updates, I have switched to it.

Sign in to comment.

More Answers (0)

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!