Read and Query JDBC not working due to missing ojdbc jar in Canara Environment

Setup & Configuration
1

In case of the below error while using Read and Query JDBC, after doing Refresh Schema in the workflow:

image
image1600×721 118 KB

These are the below steps used to be followed to resolve the above issue :

In case if you are logged in as Non Admin user, then log in as Admin user then :

  1. Go to Administration.
  2. Go to Application Library Jar List.
  3. Upload jar [ojdbc8-19.24.0.0.jar].
  4. Go back to workflow and Refresh Schema, Read and Query JDBC will work.