Question

1
Replies
466
Views
ABHATTCHRYA Member since 2010 11 posts
Cognizant Technolgy Solutions
Posted: June 12, 2018
Last activity: June 12, 2018
Closed

Exceptions for RDB methods is not getting handled from within PRPC

As a part of our requirement we are dynamically setting the select variables and table names to execute a select query using RDB-List . PRPC is unable to handle Errors or Exceptions if any invalid table names or Columns Names passed as parameter, though exception handling steps are mentioned in the activity.

It is observed from the tracer that the activity is getting terminated as soon as there is an error detected without performing exception steps.

It is not getting handled even when tried to catch the exception using listRDB method engine API method in a java step.

Please find attached the document with screen prints of the exception and the steps followed to fix these.

Please share how these can be addressed with proper exception handling.

Other relevant details -

1. PRPC version - 7.1.9

2. DB vendor - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

3. Java Version - 1.8.0_112

Thanks,

Arka Bhattacharya

Low-Code App Development Data Integration Java and Activities Data Integration
Moderation Team has archived post
Share this page LinkedIn