| Author | 
		  Message
		 | 
		
		  | phanish | 
		  
		    
			  
				 Posted: Fri Jun 07, 2013 11:25 am    Post subject: rolling back the messages from queue | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 04 May 2013 Posts: 30
  
  | 
		  
		    
			  
				Hi All,
 
 
I have a requirement like I have to write multiple messages to a queue.This part I am handling in Data Power. when the request comes to Data Power with multiple contracts(for eg) I am making a query call for each contract and building the message for each contract(if it is success after database query) and writing it to a queue. If there is any failure in any of the contract during query call or during validation I have to roll back already placed messages in the queue. Could you please suggest me how to implement this. Thanks in advance. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Fri Jun 07, 2013 11:33 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				I don't know much about DataPower, but in a normal application I'd put all the messages in the same UoW and only commit it when I was done. _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | phanish | 
		  
		    
			  
				 Posted: Fri Jun 07, 2013 12:02 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 04 May 2013 Posts: 30
  
  | 
		  
		    
			  
				| could you please elaborate on how to Commit. Do we have to set any PMO. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Fri Jun 07, 2013 12:20 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| phanish wrote: | 
   
  
	| Do we have to set any PMO. | 
   
 
 
 
The word you need to research is SYNCPOINT _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | phanish | 
		  
		    
			  
				 Posted: Fri Jun 21, 2013 9:50 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 04 May 2013 Posts: 30
  
  | 
		  
		    
			  
				| using pmo option SYNCPOINT and setting UoW as 1,I am able to commit and roll back the messages. But I have a confusion whether to use SYNCPOINT everytime we are writing messages to queue or only for the first time. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | bruce2359 | 
		  
		    
			  
				 Posted: Fri Jun 21, 2013 12:44 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Poobah
 
 Joined: 05 Jan 2008 Posts: 9486 Location: US: west coast, almost. Otherwise, enroute. 
  | 
		  
		    
			  
				Each MQPUT allows you to specify if the message is to be _SYNCPOINT or NO_SYNCPOINT.  Same with MQGET.
 
 
As suggested earlier, research mq+syncpoint. _________________ I like deadlines. I like to wave as they pass by.
 
ב''ה
 
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |