SqlTableGatewayListener does not support synchronous deliver

[tjuchniewicz]

My requirement for SqlTableGatewayListener:

1. Application stores data in sql table.
2. SqlTableGatewayListener gets data from table and delivers data to my action (ex. SOAPClient).
3. On SOAPClient success SqlTableGatewayListener change status-column in table to "D" (Done), but on SOAPClient failure change status to "E" (Error).
4. Application operator reviews records with "E" status.

Now SqlTableGatewayListener gets records from table and change status to "D" even if actions invoked next fails.

[tfennelly]

Under the current arch you'd need to manually update the status field from the action pipeline, if a failure occurs. The gateway marks the field as done because it is actually done with the record - it has successfully delivered it async to the pipeline. The error has occurred asynchronously.

Are you in a position to rejig the problem?

[tjuchniewicz]

OK. Yes I can rejig the problem.

[kconner]

What is missing from the original posting is that this is related an issue that was raised in JIRA and I asked for it to be moved here so that it could be discussed.

The issue requested synchronous behaviour to be added to the gateway and, as I commented on the issue, this is neither desirable nor safe in a transactional environment.

The issue is https://jira.jboss.org/jira/browse/JBESB-2207

[kconner]

I am going to move this topic to the design forum