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:
And I still get the same error. Any suggestions on how to further troubleshoot this?
采纳的回答
MathWorks Support Team
2022-5-13
0 个投票
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2021-9-16
2022-5-13
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
