| Author |
Message
|
| aleksawka.danilov |
 Posted: Mon Jun 30, 2014 7:48 am Post subject: Publication's transaction |
 |
|
Newbie
Joined: 30 Jun 2014
Posts: 2
|
Hello.
My main flow invoke subflow, where i use Publication node.
I wrote ESQL code in a compute node, before Publication node:
SET OutputRoot.Properties.Transactional = false;
But where main flow is roll back, then message sended by subscribtion deleted. I use IIB version 9.0.0.0
Any suggestions? |
|
| Back to top |
|
 |
| aleksawka.danilov |
| Posted: Tue Jul 01, 2014 12:23 am Post subject: |
|
|
Newbie
Joined: 30 Jun 2014
Posts: 2
|
SET OutputRoot.MQMD.Transactional = false;
and  |
|
| Back to top |
|
|
| McueMart |
| Posted: Tue Jul 01, 2014 3:26 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
At least in WMB v8, Publication nodes are non-transactional , and cannot be changed from this .Im not sure if this design oversight has been rectified in v9 though...
If not, it's probably time to raise an RFE to request it.
The workaround is to use an MQ Output node (with Transaction Mode set to Yes) instead of the Publication node - and have a separate flow which publishes the message after reading it from a queue. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jul 01, 2014 9:16 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| McueMart wrote: |
The workaround is to use an MQ Output node (with Transaction Mode set to Yes) instead of the Publication node - and have a separate flow which publishes the message after reading it from a queue. |
IMHO, the better solution is to write the message with an MQOutput Q to an ALIAS Q that is setup to write to a Topic rather than another Queue. You can control the Transactionality of the message with the line of ESQL already posted.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jul 01, 2014 9:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
That doesn't allow you to publish to a dynamic topic.
 |
|
| Back to top |
|
|
|
|
