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 » Stored procedure exception handling

Post new topic  Reply to topic
 Stored procedure exception handling « View previous topic :: View next topic » 
Author Message
pawargmat
PostPosted: Tue Apr 15, 2008 5:43 am    Post subject: Stored procedure exception handling Reply with quote

Novice

Joined: 13 Feb 2004
Posts: 14
We are planning to call Oracle stored procedures from within WBIMB V5.

I have been able to call them successfully.

I want to know how people who have used it in production handled errors.

The idea is that we should identify fatal errors (like database down, or stored procedure mismatch due to updates etc) and take appropriate action (say get inhibit queue automatically etc).

What are the most reasonable errors to catch and where?

Please let me know your thoughts.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Apr 15, 2008 5:53 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
You should be upgrading to v6, and not planning or developing new deployments to v5.

It goes out of support in September.

All of the rest of your questions depend entirely on the SLA of the application, and the practices of your site. And most of this should be handled outside your application.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
pawargmat
PostPosted: Tue Apr 15, 2008 9:19 am    Post subject: Reply with quote

Novice

Joined: 13 Feb 2004
Posts: 14
Migration to V6 is being done. We are implementing this solution using V5 for the moment as it is required.

Talking to Oracle guys, apparently there is no recognized set of errors that can be checked.

So, I am checking for the presence of name of the stored procedure or
'DatabaseException' in the Exception List to stop the execution of the flow. Will see how that goes.
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 » Stored procedure exception handling
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.