MQSeries.net :: View topic - Database input node Failure terminal issue

venkat_chekka · Posted: Mon Jul 28, 2014 11:46 am Post subject:

Hi,
I am seeing weird behavior in Database input node. See below details.

Requirement:

1) Using Database input node to get the record if any new event arrives in database table.
2) Should send response message for any database connectivity/failure issues when database is not available after retry few times based on retry mechanism property in database input node.

Message Broker Version and tool kit version: 8.0.0.2

Current settings at database input node: Currently I am not setting any retry mechanism at Database input node level and using default retry property which is 'Failure'. I should get failure through Database input node failure terminal if database is not available.

Issue: I stopped database to make it fail at database input node. But I am not getting any failure at Database input node failure terminal.

Not getting any failure when I use below either RESIGNAL statement OR default database procedure HandleDatabaseError.

Could someone let me know why is it is not working as expected?

ESQL Code:

With RESIGNAL
RESIGNAL; /* pass the error back to the node */

/* To choose to handle Database errors yourself, delete the RESIGNAL statement above
* and uncomment the following procedure call */
--CALL HandleDatabaseError('ReadEvents');

With Database handler error:

--RESIGNAL; /* pass the error back to the node */

/* To choose to handle Database errors yourself, delete the RESIGNAL statement above
* and uncomment the following procedure call */
CALL HandleDatabaseError('ReadEvents');