JDBC Driver Error: No suitable driver found when trying to query databases

When trying the query oracle database, I get the following error information:

JDBC Driver Error: No suitable driver found for jdbc:oracle:thin

This only happens when querying from a particular user account on this machine. The other accounts are working fine. I have tried to add the oracle driver JAR file path to a "javaclasspath.txt" in the "prefdir" following the steps in the link below:

https://www.mathworks.com/help/matlab/matlab_external/static-path-of-java-class-path.html?s_tid=srchtitle

And I still get the same error. Any suggestions on how to further troubleshoot this?

Answer 1

[MathWorks Support Team]

Please first make sure you have added the right driver path and have successfully added that to the static java path. To check that, please execute the "javaclasspath" command and you should be able to see the path under the "STATIC JAVA PATH" section.

Next, please make sure this user account you are using has the read permission of the JAR file. To do that, please try to read the JAR file. Since the JAR files are zip files, you could try to open it with a ZIP utility. Or you could also double click on the JAR file and see if it causes any error.

If you are using Windows system and the user account doesn't have the read permission, please go to the driver directory and right click on the jar file and select "properties". Under the “Security” tab, select the user account in the “Group or usernames” panel and then you could see the account’s permission information in the “Permission for ...” panel. Click on "Advanced" and then click on "Add". Add a principle that applies to "Everyone" and grant "Full control".

If you are granting permission to a folder that contains the driver file, please also click on "Enable inheritance" and check "Replace all child object permission entries..." after adding the permission entry. This will make sure this permission is cascadingly granted to the child objects of the folder.