MQSeries.net :: View topic - Deadlock calling SQL procedure through ESQL node

ajayrana

Hi,

I am making flow where the input request data is inserted into the MSSQL DB and then a stored procedure is called to process the same.

Message Flow:

HTTPInput --> Mapping Node --> ESQL --> HTTPReply

The data from HTTPInput is coming in Mapping node and the same is getting inserted in table T1 while table T2 is getting updated in the same map. After the mapping node i am calling a SQL procedure [third part system code] which then does some processing and updates the Table T1 record with status processed.

Now the update to Table T1 is not happening in the flow and it goes into a lock state. The procedure call is working fine if i update table T3. It seems there is some commit issue which i m unable to understand.

Please let me know if I am missing something here.

Thanks & Regards
Ajay Rana