Process Automation is unable to query database through the JDBC Operator. A JDBC error is returned, such as this error from Oracle:"Could not load database driver: oracle.jdbc.OracleDriver"
This is due to the JDBC driver not being loaded into Process Automation as an available resource.
To be able to use a JDBC driver with the JDBC operators, that JDBC driver needs to be deployed as a Resource. This can be done during the installation, or can through the interface after the installation is complete.
Please see: https://docops.ca.com/display/CATPA43/Deploy+JDBC+Drivers+for+Database+Operators
To deploy a JDBC resource for the Orchestrator:
Enter the name of the resource in the Resource Name field.
The following example is a reasonable way to specify the resource name if you are uploading a JDBC driver:
Verify your entry, and then click Save.
A line that contains your entry displays.
CA Process Automation copies the uploaded resource to the following paths:
After mirroring occurs, restart all other Orchestrators.
The system deploys all uploaded jars to all Orchestrators. That is, the system puts the jars in the classpaths of the Orchestrators.