I want to insert the data into DB through JDBC adapter and I am using transaction handling for which is in inside a LOOP.
the steps as follows
LOOP over document list
calling jdbc adapter for insertion
The problem is:
since I am using transaction handling in LOOP the following error occurs
ERROR 25.11.08 15:11:01 || 150953.164 : [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service rbaapagos.adapters:insertPaGOS_out_t.
[ART.117.4011] Adapter Runtime (Adapter Service): Unable to connect to resource rbdbconnections.rbaapagos:aapagos. The resource is already being used in a parent transaction”
could anyone suggest a solution to overcome this issue.