MQSeries.net :: View topic

YaleM4208

I'm using a DatabaseInput node under WMB v7.0.0.4. Everything works fine under normal settings. I have coded a "throw user exception" statement downstream to test the error handling of the input node. The retry is set to Short and Long, threshold=3, short interval=10 and long interval = 30. It is not honoring the retry threshold though and I can not get it to send anything out the failure terminal. Has anyone experienced this before?

P.S. The code that gets auto-generated when adding a DBInput node has the following comment.

[code]
/*
* This DatabaseEvent module implements the ESQL code invoked from a DatabaseInput node to handle
* events as they move through the states of New->Ready->Dispatched->Complete.
*
* NOTE: Events that result in unhandled exceptions in the message flow are moved to the Failed
* state. "Unhandled" means either that the catch terminal was not wired, or that the catch
* terminal threw an exception. If an exception is unhandled, the transaction is rolled back.
* If the exception is handled, even if it is handled on the catch terminal, the transaction is
* committed.
*
* Events are moved to the Failed state after rollback (or after a number of retries, depending
* on the settings on the Retry panel). Events in the Failed state are propagated to the Failure
* terminal. If they are not handled on the failure terminal, they are discarded. They are
* still in the EventTable, and so are not lost.
*
*/
[/code]