Configure JDBC connection on Mojave

Question

Gian23 2019-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461510-configure-jdbc-connection-on-mojave

回答： TARUN 2025-6-11

Hi, I'm new in the community but before to make my question I tried unsuccessfully to find the answer in a lot of topics.

I need to create a connection by code to a localhost mySQL database in OSX Mojave.

First of all I downloaded the Connector/J 8.0.16 Platform Independent driver called 'mysql-connector-java-8.0.16.jar' and I copied it in a subfolder of my rootfolder called Jconnector with the following code:

rootfolder = '/Users/User/Documents/MATLAB/MatlabResearch/RobustTS/';
addpath(rootfolder);
    % jdbc
    jdbcfolder = [rootfolder 'Jconnector/'];
    jdbcjarfile = 'mysql-connector-java-8.0.16.jar';
 
    % database
    databasename    = 'RAWDATA';
    user            = 'root';
    password        = 'password';
    driver          = 'com.mysql.cj.jdbc.Driver';
    databaseurl     = ['jdbc:mysql://localhost:3306/' databasename];    
    
    % table name(s)
    table_indexed       = 'mytable';
    table = table_indexed;
    
    % add jdbc driver info
    javaaddpath([jdbcfolder jdbcjarfile]);
    % connect to database
    conn = database(databasename, user, password, driver, databaseurl);
    

And I get this error:

    Warning: Invalid file or directory
'/Users/User/Documents/MATLAB/MatlabResearch/RobustTS/Jconnector/mysql-connector-java-8.0.16.jar'. 
> In javaclasspath>local_validate_dynamic_path (line 271)
  In javaclasspath>local_javapath (line 187)
  In javaclasspath (line 124)
  In javaaddpath (line 71) 
  
  

And the message in the connection proprierties. 'No suitable driver found ...'

I can't understand if my procedure fails in the code of in some preliminary step (like managing of JAVACLASS).

Could someone help me? I would be very glad.

Thanks in advance,

Gian

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

请先登录，再进行评论。

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

Answer 1

TARUN 2025-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461510-configure-jdbc-connection-on-mojave#answer_1566288

Hi @Gian23,

It looks like you're trying to connect MATLAB to a local MySQL database using the JDBC driver on macOS Mojave, but you're running into issues like "invalid file or directory" for the .jar and a "no suitable driver found" message.

This usually happens due to either the driver not being properly located or registered, or a misstep in the configuration. You can try the following steps to resolve the problem:

Make sure the path to the .jar file is correct, and the file exists at that location.
Use fullfile() instead of string concatenation when forming file paths, to avoid formatting issues especially on macOS.
Run javaclasspath('-dynamic') to verify that the JDBC .jar was successfully added to MATLAB’s Java classpath.
Double-check that the MySQL server is running and accessible at localhost:3306, and that login credentials and database name are correct.