MQSeries.net :: View topic

Yars13 · Posted: Thu Oct 21, 2004 2:56 am Post subject:

I'm not sure if this is the correct forum to post on, but here's my question. I am trying to develop code to put and get messages from queues and handle disasters with grace. Maybe someone can suggest some techniques or point me in the right direction, i've never used MQseries before and can only do simple Puts/Gets at this point.

I'm using C#, MQSeries 5.3 client and server, SQL Server. First the Put. I need to get some data from the DB, formatt it, put on the queue, then update the DB, in that order and make sure that if there is some disaster somewhere in the middle, then nothing gets updated or put on the queue.

Similarly, when i get the message from the queue. I need to get the message, formatt it and then put it in the database, in that order. Here i need to make sure that in order not to lose anything, if there is a disaster and the database doesn't get a chance to get updated, then the message doesn't get taken off the queue and lost forever. So i need it to stay on the queue until i can come back and try to get it again.

If anyone has any suggestions on how this can be done i would really appreciate it. Thanks in advance.

Yars