MQSeries.net :: View topic

bdaoust · Posted: Wed Jun 01, 2016 12:28 pm Post subject: Question About Database Commit.

Hello everyone.

We have a message flow in IIB9 that has a SOAP Input node.

The SOAP Request is stored in a database so that the ReplyIdentifier can be later be return on the response. Furthermore, this database insert is via a database note that calls a stored procedure. I didn't write this message flow and if it were me, I would use message headers to store and retrieve the SOAP Reply Identifier.

We have been having random "No SOAP Reply Identifier At All" issues and after much troubleshooting, I found that the database transactions above hadn't committed in time for the response to retrieve it. While some work just fine (this has been in place for years) it just seems like either the responses are coming back quicker or the database transaction is slower.

I've set the database node for Automatic to Commit for the Transaction and it now is committing the record immediately. Besides the fact that I will need to rollback committed transactions if something in the flows fails, are there any other considerations I should take? PS - I did set the transaction to commit for all other nodes in that flow. When I didn't at first I got the "Will commit, but pending transaction" warning.

Ultimately, I want to use message headers as stated above, but for now, I'd like to go with this approach.

Thanks
-B