| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Exceptions in database nodes... |
« View previous topic :: View next topic » |
| Author |
Message
|
| Empeterson |
 Posted: Tue Oct 28, 2003 9:57 am Post subject: Exceptions in database nodes... |
 |
|
Centurion
Joined: 14 Apr 2003
Posts: 125
Location: Foxboro, MA
|
I have some database updates within a flow, but do not want any database exceptions to stop processing of the message. If any exceptions occur, I just want the message to continue going on its merry little way through the rest of the flow. I have unchecked the 'Treat Warnings as Error' and 'Throw Exception on database error' checkboxes, I have turned the 'Transaction Mode' to off on the input node, but an exception is still being thrown. I was under the assumption that WMQI would just ignore any database errors if you had the 'Throw Exception on database error' box unchecked, but that does not seem to be the case. What can I do to ignore any database exception?
_________________
IBM Certified Specialist: MQSeries
IBM Certified Specalist: Websphere MQ Integrator |
|
| Back to top |
|
 |
| Craig B |
| Posted: Tue Oct 28, 2003 10:18 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
Some database errors are seen to be Recoverable and some are not recoverable. What error are you receiving in this case?
Thanks.
_________________
Regards
Craig |
|
| Back to top |
|
|
| Empeterson |
| Posted: Tue Oct 28, 2003 10:29 am Post subject: |
|
|
Centurion
Joined: 14 Apr 2003
Posts: 125
Location: Foxboro, MA
|
There are 2 errors in particular that I have noticed this happening on. One was the database connection had timed out, so when the next message came in, WMQI had no connection to the database. The message would fail and WMQI would re-establish its connection. All subsequent message would be successful. The other was I would intentionally enter in a bad DSN in order to get an execption thrown. I guess these would be of the irrecoverable kind? I suppose I can just wire the failure terminal of the database node up directly to the same node that the out terminal is wired too, since the flow doesnt need to be transactional.
_________________
IBM Certified Specialist: MQSeries
IBM Certified Specalist: Websphere MQ Integrator |
|
| 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
|
|
|
|
