MQSeries.net :: View topic - Rollback DB insert on exception in Flow-flw complete normaly

jbanoop · Posted: Mon Nov 21, 2005 3:02 pm Post subject:

Hi All,
This is Anoop here.
I am having a setup in which there is a compute node doing an DB insert operation (using the passthru()) after with I am attempting an FTP transfer.

The requirement is that in case of an FTP error, I need to send an Email and roll back the DB insert which happened previously.

So the failure terminal of the node doing the FTP is wired to a flow order node to first send the email and then throw another exception as teh second step.
This exception goes back across the compute node doing the insert and is caught after that and handled.

The exception is thus handled and the message flow completes properly. However I need the insert to be rolled back in case of an FTP error. Is there any setting that could do this rollback (other than using a delete statement to explicitly remove the record)?

The transaction property is set to automatic on the compute node doing the insert.

To summarize the setup:
trycatch (try term)-> computenode doing DB insert(out term) -> Ftp node doing FTP (failure term) -> flow order (first send email, second throw user exception)

Any help is appriciated.
Regards,
Anoop