Hi,
We have a requirement to build a custom JAR for a use case. The JAR needs to execute a query against a remote Oracle DB and retrieve the result of the query. In order to execute the query on the Oracle DB from the JAR, we have added ojdbc8.jar driver as a dependency to our custom JAR.
When creating the JAR, we are adding all the dependencies into the JAR, including ojdbc8.jar file.
- In our local development environment, we are able to execute the query on Oracle DB using ojdbc8.jar driver.
- Additionally, when running the JAR outside of Saviynt, we are able to fetch the results from Oracle DB. We have added loggers in our code to verify the JAR execution.
Issue:
We have deployed our JAR in Saviynt from Admin > Settings > File Directory > External JARs. Also, restarted the system in order for changes to take effect and waited for 20 mins.
Post the JAR deployment, we are invoking the JAR using a job of type - "Invoke Extension JAR Job (ExternalJarJob)". On running the job, we have observed that saviynt is not able to find a suitable driver to execute the query on Oracle DB. Message:
SQL State: 08001 No suitable driver found for jdbc:oracle:thin@ldap://oracledb:1521/A123,cn=oracle,dc=example,dc=com
Any thoughts on why we are getting this error?
Thanks,
Kunal
