How can this be solved

[Chris]

Hi,
I have a service that collects messages form MSMQ to enter to a database.
What I notice is that if at the same time, during the process of sending the
queued message data to the database, I disconnect the cable, the data
obvoiusly don't go to the database but I happen to loose the queued message
it was currently inserting. Is there a way to perform a transaction on the
retrival of the queued message so that if anything breaks the process of
handling the queued message it simply returns the message to MSMQ queue?

Thanks

[Brendan Green]

See:
System.Messaging.MessageQueueTransaction

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

Hi,
I have a service that collects messages form MSMQ to enter to a database.
What I notice is that if at the same time, during the process of sending
the
queued message data to the database, I disconnect the cable, the data
obvoiusly don't go to the database but I happen to loose the queued
message
it was currently inserting. Is there a way to perform a transaction on the
retrival of the queued message so that if anything breaks the process of
handling the queued message it simply returns the message to MSMQ queue?

Thanks

[Chris]

Hi,
Isn't this a transaction that is created by the application sending the
queued message and not the application reveiving the queued message? Will
double check I may be wrong.

"Brendan Green" wrote:

See:
System.Messaging.MessageQueueTransaction

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

Hi,
I have a service that collects messages form MSMQ to enter to a database.
What I notice is that if at the same time, during the process of sending
the
queued message data to the database, I disconnect the cable, the data
obvoiusly don't go to the database but I happen to loose the queued
message
it was currently inserting. Is there a way to perform a transaction on the
retrival of the queued message so that if anything breaks the process of
handling the queued message it simply returns the message to MSMQ queue?

Thanks

[Chris]

You seem correct. I'll test. I see here the transaction is during the
receive. My app will begin processing to database after receipt. If the
connection breaks to the database would the current queue be rolled back?

"Brendan Green" wrote:

See:
System.Messaging.MessageQueueTransaction

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

Hi,
I have a service that collects messages form MSMQ to enter to a database.
What I notice is that if at the same time, during the process of sending
the
queued message data to the database, I disconnect the cable, the data
obvoiusly don't go to the database but I happen to loose the queued
message
it was currently inserting. Is there a way to perform a transaction on the
retrival of the queued message so that if anything breaks the process of
handling the queued message it simply returns the message to MSMQ queue?

Thanks

[Brendan Green]

Yes.

A snippit of what I did for a client:

----------------------------------
messageQueueTran = new System.Messaging.MessageQueueTransaction();message QueueTran.Begin();//Tryto get a message from the queue. Set the timeout to the value provided. myMessage = messageQueue.Receive(new TimeSpan(0, 0, m_timeout), messageQueueTran);// Do some processing// if processed okmessageQueueTran.Commit();----------------------------------
If there was a problem, we'd call mnessageQueueTran.Abort(), which would put the message back on the queue.

"Chris" <Ch***@discussions.microsoft.com> wrote in message news:A3**********************************@microsof t.com...

You seem correct. I'll test. I see here the transaction is during the
receive. My app will begin processing to database after receipt. If the
connection breaks to the database would the current queue be rolled back?

"Brendan Green" wrote:

See:
System.Messaging.MessageQueueTransaction



"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

> Hi,
> I have a service that collects messages form MSMQ to enter to a database.
> What I notice is that if at the same time, during the process of sending
> the
> queued message data to the database, I disconnect the cable, the data
> obvoiusly don't go to the database but I happen to loose the queued
> message
> it was currently inserting. Is there a way to perform a transaction on the
> retrival of the queued message so that if anything breaks the process of
> handling the queued message it simply returns the message to MSMQ queue?
>
> Thanks

[Chris]

Hi,
I am getting the error when I try to receive a transactional message from MSMQ

"The transaction usage is invalid"

I am using direct format names to send and receive the messages. Is that a
problem? Without transaction it works fine. Only when I enable transaction I
get the problem.

Thanks

"Brendan Green" wrote:

Yes.

A snippit of what I did for a client:

----------------------------------
messageQueueTran = new System.Messaging.MessageQueueTransaction();message QueueTran.Begin();//Try to get a message from the queue. Set the timeout to the value provided. myMessage = messageQueue.Receive(new TimeSpan(0, 0, m_timeout), messageQueueTran);// Do some processing// if processed okmessageQueueTran.Commit();----------------------------------
If there was a problem, we'd call mnessageQueueTran.Abort(), which would put the message back on the queue.

"Chris" <Ch***@discussions.microsoft.com> wrote in message news:A3**********************************@microsof t.com...

You seem correct. I'll test. I see here the transaction is during the
receive. My app will begin processing to database after receipt. If the
connection breaks to the database would the current queue be rolled back?

"Brendan Green" wrote:

See:
System.Messaging.MessageQueueTransaction

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...
> Hi,
> I have a service that collects messages form MSMQ to enter to a database.
> What I notice is that if at the same time, during the process of sending
> the
> queued message data to the database, I disconnect the cable, the data
> obvoiusly don't go to the database but I happen to loose the queued
> message
> it was currently inserting. Is there a way to perform a transaction on the
> retrival of the queued message so that if anything breaks the process of
> handling the queued message it simply returns the message to MSMQ queue?
>
> Thanks

[Brendan Green]

Make sure that the queue is a transactional queue (there is a checkbox when
creating a new queue).

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:59**********************************@microsof t.com...

Hi,
I am getting the error when I try to receive a transactional message from
MSMQ

"The transaction usage is invalid"

I am using direct format names to send and receive the messages. Is that a
problem? Without transaction it works fine. Only when I enable transaction
I
get the problem.

Thanks

"Brendan Green" wrote:

Yes.

A snippit of what I did for a client:

----------------------------------
messageQueueTran = new
System.Messaging.MessageQueueTransaction();message QueueTran.Begin();//Try
to get a message from the queue. Set the timeout to the value provided.
myMessage = messageQueue.Receive(new TimeSpan(0, 0, m_timeout),
messageQueueTran);// Do some processing// if processed
okmessageQueueTran.Commit();----------------------------------
If there was a problem, we'd call mnessageQueueTran.Abort(), which would
put the message back on the queue.

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...

> You seem correct. I'll test. I see here the transaction is during the
> receive. My app will begin processing to database after receipt. If the
> connection breaks to the database would the current queue be rolled
> back?
>
> "Brendan Green" wrote:
>
>> See:
>> System.Messaging.MessageQueueTransaction
>>
>>
>>
>> "Chris" <Ch***@discussions.microsoft.com> wrote in message
>> news:60**********************************@microsof t.com...
>> > Hi,
>> > I have a service that collects messages form MSMQ to enter to a
>> > database.
>> > What I notice is that if at the same time, during the process of
>> > sending
>> > the
>> > queued message data to the database, I disconnect the cable, the
>> > data
>> > obvoiusly don't go to the database but I happen to loose the queued
>> > message
>> > it was currently inserting. Is there a way to perform a transaction
>> > on the
>> > retrival of the queued message so that if anything breaks the
>> > process of
>> > handling the queued message it simply returns the message to MSMQ
>> > queue?
>> >
>> > Thanks
>>
>>
>>