JDBC Driver Error: No suitable driver found when trying to query databases
22 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
MathWorks Support Team
el 16 de Sept. de 2021
Editada: MathWorks Support Team
el 13 de Mayo de 2022
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?
Respuesta aceptada
MathWorks Support Team
el 13 de Mayo de 2022
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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!