Why is MATLAB unable to find the JDBC Driver?

Question

Raymond Chiu 2018-7-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411808-why-is-matlab-unable-to-find-the-jdbc-driver

评论： Karim Ushama 2021-5-26

Attempts, from MATLAB, to connect to a database fail.

    conn = database(dbsource,username,password,'Vendor','MySQL', 'Server','mysql8.db4free.net','portnumber',3306)

Error message: *Unable to find JDBC driver*

[![enter image description here][1]][1]

The [JDBC driver][2] was:

 - copied from [https://dev.mysql.com/downloads/file/?id=477058][3]
 - copied to C:\drivers\mysql-connector-java-8.0.11\mysql-connector-java-8.0.11.jar
 - added to the JDBC static path
 - path \ filename was verified:

[![enter image description here][4]][4]

QUESTIONS ====

1) Is there enough information here to diagnose the root cause of the error message?

2) What is the root cause and corrective action?

3) Why does MATLAB indicate the JDBC driver file is not on the java classpath? Remedy?

Responses to requests for additional diagnostic information will be added to the original posting.

UPDATE === Attempt to configure MATLAB's database explorer app returned the message:

JDBC driver file was not found on MATLAB java classpath

[![enter image description here][5]][5]

Java version:

[![enter image description here][6]][6]

[1]:

[2]:

https://www.mathworks.com/help/database/ug/mysql-jdbc-windows.html

[3]:

https://dev.mysql.com/downloads/file/?id=477058

[4]:

[5]:

[6]:

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2018-7-24

You show the JAVA dynamic path as being empty. I do not see where you are adding C:\drivers\mysql-connector-java-8.0.11\mysql-connector-java-8.0.11.jar to your MATLAB classpath ?

请先登录，再进行评论。

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

Answer 1

Raymond Chiu 2018-7-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411808-why-is-matlab-unable-to-find-the-jdbc-driver#answer_330215

A clever peer solved this problem with V5.1:

Connector/J 8.0 (including mysql-connector-java-8.0.11.jar) supports only JRE 1.8.x. But MATLAB R2017a uses JRE 1.7, so mysql-connector-java-8.0.11.jar is not supported in R2017a.

Connector/J 5.1 Connector/J 5.1 supports JRE 1.7, so it works with MATLAB R2017a and also it supports MySQL Server 8.0.

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

请先登录，再进行评论。

Answer 2

Pieume Ulrich 2019-5-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411808-why-is-matlab-unable-to-find-the-jdbc-driver#answer_373182

Hello guys I'm using the R2017b and i consulted the version of my JRE and saw that it was 'Java 1.8.0_121-b13'. with this advance i am eligable for the 'mysql-connector-java-8.0.11.jar' driver but yet I still have the same response 'JDBC driver is not found on MATLAB java class path'.

Please I would like to have the complete procedure to connect my MATLAB to mysql using 'JDBC' driver please,

ùy email: pieumeulrich@gmail.com