ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Transaction/isolation level in WBIMB 5

Post new topic  Reply to topic
 Transaction/isolation level in WBIMB 5 « View previous topic :: View next topic » 
Author Message
martinrydman
PostPosted: Mon Mar 15, 2004 3:52 am    Post subject: Transaction/isolation level in WBIMB 5 Reply with quote

Centurion

Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
Hi!

We got this simple scenario:

A flow is deployed on a number of clustered brokers. Load balancing distributes messages evenly to all instances of the flow.

A fragment of the flow does the following:

INSERT some values into a table
SELECT COUNT(*) from the same table

Our tests indicate that the isolationlevel of a transaction is read committed, i.e. each instance of the flow only sees its own INSERT, and so the COUNT(*) will only return the instances's record, not records inserted by other instances (that have occured simultaniously).

Anyone have any experience with this type of problem? Any hints greatly appreciated!

TIA

/Martin
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Transaction/isolation level in WBIMB 5
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.