| Author |
Message
|
| alokamit72 |
 Posted: Tue Jul 05, 2011 1:09 am Post subject: Regading MQInput node |
 |
|
Newbie
Joined: 02 Jun 2011
Posts: 8
|
Hi,
In MQ Input node i can see Transaction Mode Property and the option is Automatic,Yes , and no. In which senario we set Automatic, Yes and No.?
Regards
Amit |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Jul 05, 2011 4:18 am Post subject: Re: Regading MQInput node |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| alokamit72 wrote: |
| In which senario we set Automatic, Yes and No.? |
In scenarios where you want the transactionality of the flow to be true, false or automatically determined according to your design.
You'll find this described in the node's documentation. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 05, 2011 4:40 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
99 percent of the time it will be set to "no".
Have you attended the WMB Developer's training course? Many of your questions recently asked would be addressed by the instructor.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jul 05, 2011 4:43 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| 99 percent of the time it will be set to "no". |
On what do you base that assertion? Again, you're presenting personal opinion as fact - "it will be" - without establishing criteria.
| lancelotlinc wrote: |
| Have you attended the WMB Developer's training course? Many of your questions recently asked would be addressed by the instructor. |
Training! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 05, 2011 4:48 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Sir Vitor, please offer your differing opinion. In your experience, having ten apples, how many of the ten apples would be set to "no" if they were MQInput nodes?
In memory of Peter Falk, Columbo: you have three bags of gold. Two of the bags of gold contain real gold coins, each coin weighing precisely one ounce. One bag of gold contains fake coins, each fake coin weighing 1.1 ounces. Having the opportunity to use a scale to make a weight measurement ONLY ONCE, how would you figure out which bag contains the fake coins, and what two bags contain the real gold? You cannot take two weight measurements, only one.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jul 05, 2011 4:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| Sir Vitor, please offer your differing opinion. |
Why? You didn't offer an opinion, you presented a fact. To a poster you'd already identified as inexperienced and untrained. If you'd used the phrase "In my opinion" or even "In my experience" I wouldn't have said a word.
| lancelotlinc wrote: |
| In your experience, having ten apples, how many of the ten apples would be set to "no" if they were MQInput nodes? |
In my experience, 40 - 50% of flows have transactionality set true becuase they're updating a database and/or require message rollback.
Though 90% of the flows I encounter use Automatic because no-one's bothered to set it. 5% have Automatic because transactionality's being controlled by persistence.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jlaisbett |
| Posted: Tue Jul 05, 2011 12:34 pm Post subject: |
|
|
Apprentice
Joined: 27 Nov 2009
Posts: 39
|
From what I've seen you don't need transactions enabled for an MQ Input node to get transactions for a database update, the database calls are still done inside a transaction anyway ... Or maybe that depends on which approach is being used?
I've seen it mostly used for MQ back outs and persistent messages, although I've also seen it a lot because it's turned on by default and nobody changed it. Another use is for globally co-ordinated transactions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jul 05, 2011 12:48 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| jlaisbett wrote: |
| From what I've seen you don't need transactions enabled for an MQ Input node to get transactions for a database update, the database calls are still done inside a transaction anyway ... Or maybe that depends on which approach is being used? |
Flows only use transactions if transactionality is true, either because it's been deliberately set true or the transactionality has been left as the default (automatic) and WMB has determined that transactions are to be used.
| jlaisbett wrote: |
| I've also seen it a lot because it's turned on by default and nobody changed it. |
This would be my guess. The default is Automatic.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
