JDBC warning message: "..... The new driver class is `com.mysql.cj.jdbc.Driver'...."
155 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
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.
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!