JDBC asynchronous call - update
Scenario: Proxy to JDBC (asynchronous call)
The process sends an update command to the database. The where clause does not exist i.e. The record can not be updated since it does not exist
(data on database recid = 1, 2, 3)
(update where recid = 10)
The message is marked in message monitoring as successful, I would have expected the message to fail since the update can not happen.
Is this the correct behaviour? If yes, how can I get the message to fail to notify the administrator that there is an issue.