| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| read /update uncommitted database data |
« View previous topic :: View next topic » |
| Author |
Message
|
| gs |
 Posted: Mon Feb 08, 2010 4:39 am Post subject: read /update uncommitted database data |
 |
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
I'm working on an integration that takes an input message and inserts into / updates various tables in a DB2 database. I'm doing all work in a compute node with the database specified as a datasource.
Now, the incoming data -> database logic is quite extensive and I'm a bit unsure about how to handle the multiple inserts / updates in the same transaction.
How do I do I specify the transaction isolation level from the compute node and can I, in the same transaction, first insert a row and then update it?
Thanks
EDIT: I should note that this regards WMB version 6.0 |
|
| Back to top |
|
 |
| gs |
| Posted: Mon Feb 22, 2010 4:32 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
To answer my own question, this seems to be working as I wanted (ie. uncommitted data is selected and updated without problems).
Only thing that didn't work was a trigger that didn't update the uncommitted row.
If one would want to specify the transaction level, would it be possible using ESQL/ODBC? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Feb 22, 2010 12:06 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| gs wrote: |
To answer my own question, this seems to be working as I wanted (ie. uncommitted data is selected and updated without problems).
Only thing that didn't work was a trigger that didn't update the uncommitted row.
If one would want to specify the transaction level, would it be possible using ESQL/ODBC? |
That would be difficult, as the DB trigger cannot be fired until the insert is committed... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
