ConnectALL Database adapter (Oracle) throws an 'ORA-04043 : object does not exist' error when processing a transaction

Products

• ConnectALL
• ConnectAll On-Prem
• ConnectAll SaaS

Issue/Introduction

Create a Oracle database connection

Built a Jira to Oracle database automation and setup field mapping where the columns from the data base are displayed properly.  The automation saves properly.  This would show that the connection is valid, and can pull data from the table that resides in the defined schema.  

When testing the automation, the automation throws an ORA-04043 error stating the the object <Schema_name> does not exist.

In order for this Oracle database adapter connection work, you will need to have the ojdbc.jar present in required locations. See JDBC Driver section in TechDoc.

Environment

3.x

Cause

The issue is because the ojdbc10.jar was being used. 
See JDBC Driver section in TechDoc to deploy the ojdbc jar in ConnectALL server.

Resolution

When used ojdbc8.jar there were no issues. R