I am using Local Jdbc Connection to SQL database and one of the calls are through stored procedure which is executed successfully but then next batchInsert failes due to
Unable to invoke adapter service . Unable to connect to resource.The resource is already being used in a parent transaction.
Here what I am doing:
Basically I am processing Document with implicit transaction and if exception occurred Stored Procedure called explicitly, but procedure itself has start and end transaction. When I execute it first time it works OK, but in a next loop iteration after error occurred I can not invoke executeBatchInserts with error message above
Is it because I need to handle it with start/end transaction OR I have to use no transaction connection in this case
Any help appreciated
MainServiceLoop: TryDocumentProcessService startLocalTransaction executeBatchInserts(many inserts in this block) commitLocalTransaction CatchException rollbackLocalTransaction CallStoredProcedureToLogAnException endOfLoop