MQSeries.net :: View topic - Database

vadivel · Posted: Fri Sep 14, 2007 5:36 am Post subject:

Hi,

I'm using MBv5 in my project and in my message flow, I use a common procedure that does a select from a table for a key and if not found inserts a record with the key value else updates the record. There can be more than one message flow calling the same procedure concurrently with the same key. The expected behaviour is, first flow inserts the record and the other flow updates the record. But currently, the first flow selects and finds no record and concurrently the second flow also does a select before the first flow inserts and commits the record. Hence the second flow also tries to insert the same record and throws an error. Could you please help me resolving this issues.

Thanks
Vadi