MQSeries.net :: View topic - User exception roll back

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » User exception roll back

User exception roll back

« View previous topic :: View next topic »

Author

Message

nelson

Posted: Tue Sep 08, 2015 7:06 am Post subject: User exception roll back

Partisan

Joined: 02 Oct 2012
Posts: 313

Hi all,

I'm generating an exception within a compute node (THROW USER EXCEPTION), before that, a stored procedure have executed successfully. I have not any Failure or Catch terminal wired in the flow... How can I tell the compute node to roll back the changes if a user exception is detected?

Thanks in advance.

mqjeff

Posted: Tue Sep 08, 2015 7:13 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Catch the exception in your ESQL code and issue a rollback.

Work with the transaction mode on your Compute node and make sure you know when that causes rollbacks.
_________________
chmod -R ugo-wx /

nelson

Posted: Tue Sep 08, 2015 11:15 am Post subject:

Partisan

Joined: 02 Oct 2012
Posts: 313

There was a commit within one of the SPs... so, removed this commit and now it is working as desired.

Thanks a lot.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » User exception roll back

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP