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 » File Extender question

Post new topic  Reply to topic
 File Extender question « View previous topic :: View next topic » 
Author Message
Bravo
PostPosted: Thu Nov 23, 2006 3:30 pm    Post subject: File Extender question Reply with quote

Centurion

Joined: 03 Oct 2005
Posts: 146

Hi All,

what are the consequences, if exceptions are not handle in message flows using File Extender?.

Here is the situation :

FileInput node reads Input file record by record until Endoffile and each records updated in database table and also store in a queue as a XML message.

If any exceptions occurs while reading the record, the Database updates and message in Queue should be rolled back.This is working perfect when exception are not handle (catch or failure are not handle).

But when I handle the exception the Databse updates and Queue is not rolled back.

For eg :

If I have 5 records in input file and Exception occurs in 3rd record and exception is handled then 2 rows and 2 messages are not rolled back.

Also I need to send an notification when exception occurs.

Any suggesstion
_________________
Bravo
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Nov 23, 2006 5:08 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

This has nothing to do with File Extender.

It has everything to do with basic error handling in WMB.

It is the *Input node that causes rollback to occur. If you wire a CATCH terminal on an *Input node, then you are saying that you will handle all error processing, including rollback.

I believe there's a devWorks article by Tim Dunn that goes over this.

Wire a Throw node to the end of your catch branch, and do not connect the failure terminal.
_________________
I am *not* the model of the modern major general.
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 » File Extender question
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.