| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Exception in message broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| ethirajesh |
 Posted: Fri Feb 04, 2011 2:01 am Post subject: Exception in message broker |
 |
|
Apprentice
Joined: 04 Oct 2010
Posts: 46
|
Hi Friends,
I am invoking a SP, and checking the return code returned by it in the message flow. If it is greater than 0 I am throwing an exception at that line. My question is, if at all the whole database is down or the database connectivity is not available to MB will MB throw exception automatically?
Regards
Rajesh Ethiraj |
|
| Back to top |
|
 |
| fatherjack |
| Posted: Fri Feb 04, 2011 2:40 am Post subject: Re: Exception in message broker |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| ethirajesh wrote: |
Hi Friends,
I am invoking a SP, and checking the return code returned by it in the message flow. If it is greater than 0 I am throwing an exception at that line. My question is, if at all the whole database is down or the database connectivity is not available to MB will MB throw exception automatically?
Regards
Rajesh Ethiraj |
What happened when you tried it?
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| harish_td |
| Posted: Fri Feb 04, 2011 5:07 am Post subject: Re: Exception in message broker |
|
|
Master
Joined: 13 Feb 2006
Posts: 236
|
| ethirajesh wrote: |
| My question is, if at all the whole database is down or the database connectivity is not available to MB will MB throw exception automatically? |
AFAIK, There is no out-of-the-box way that Message Broker detects that a Stored procedure or the database is down.
Have you reviewed the below link?
http://www.mqseries.net/phpBB2/viewtopic.php?t=53592&start=0&postdays=0&postorder=asc&highlight=
Credit where credit is due, we use the method suggested by fatherjack in our stored procedure calls. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Feb 04, 2011 5:14 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Yes, broker should throw an exception.
You should be testing this, rather than asking this. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Feb 04, 2011 6:53 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
And don't even think of trying to code for all the different exception types.
One customer wanted this. Then I showed him all the possible exceptions that the DB or the network link going down could produce. Then I told him how long it would be to code them all and then test everyone.... 
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
