We have a requirement to poll db, we will update a field on table for the polled records. After applying some teansformations to these records, these will be published to JMS queue.
We want to maintain transaction here, so that if the JMS publish fails, the record is not lost and will be retried.
Could you please let me know if this is possible? Then how it can be achieved, and what will happen to the feild that is updated in DB after DB polling? will that be reset?
If you are using XA transaction in your data source definition (to poll the data from the DB) it will be easy for you.
When there is an exception on the JMS invocation, the poll data will be rolled back(assuming between the receive & invoke activity you have only assign/trans' activity).
Do a small test....