| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| SQL Stored Procedures in DBInput or DataInsert nodes |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqnewbie771 |
 Posted: Tue Jun 11, 2013 11:00 am Post subject: Doing the same in V8 |
 |
|
Newbie
Joined: 10 Jun 2013
Posts: 5
|
Hi
Did anyone figure out if this can be done? I am able to call the stored procedure from DBInput node on EndEvent. But seems to have no effect. the row is again picked up by readevents.
can you please share the solution if u did find one? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Tue Jun 11, 2013 11:44 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| mqnewbie771 |
| Posted: Tue Jun 11, 2013 1:43 pm Post subject: |
|
|
Newbie
Joined: 10 Jun 2013
Posts: 5
|
1. It was relevant to my issue.
2. I didnt think it was impossible. WMB isnt doing it.
3. I did read the link before i posted here. What puzzles me is that the commit after the stored procedure isnt happening. It happens with the other compute nodes. Is it because of the transaction mode 'Yes' in databaseinput node as opposed to 'Automatic' in compute nodes?
4. No I havent. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jun 11, 2013 2:10 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
DatabaseInput node definitely runs in a different transactional context than a Compute node.
Compute node transaction mode "automatic" means "use the transaction that's started (or not) by the input node that started the flow".
"Yes" on DatabaseInput node means "process each record in a transaction".
So you're trying to do your stored procedure call within the same transaction that reads the event record off the event table.
If the same row is read from the event table by the DatabaseInput node then the initial processing of the row did not complete, and so the transaction was rolled back.
Edit: Okay, I got the transactional stuff a bit wrong. See http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/topic/com.ibm.etools.mft.doc/bc34040_.htm
and notice that EndEvents runs in a separate transaction than ReadEvents. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jun 12, 2013 3:23 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqnewbie771 wrote: |
1. It was relevant to my issue.
2. I didnt think it was impossible. WMB isnt doing it.
3. I did read the link before i posted here. What puzzles me is that the commit after the stored procedure isnt happening. It happens with the other compute nodes. Is it because of the transaction mode 'Yes' in databaseinput node as opposed to 'Automatic' in compute nodes?
4. No I havent. |
It may be relevant, but you should start your own post for many reasons. Your situation may have differences than the OPs. When you open years old posts, all the people get an email on the old chain.
SP commits are managed inside the SP. If your data is not getting COMMITed, modify the SP. If you choose, you can also issue a stand-alone COMMIT in ESQL.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
