1. Configured DB Adapter to poll rows with status 'notprocessed' and set the status to 'processed'
2. Configured FTP Adapter to write fetched rows from DB into a CSV file
Now my requirement is if any error like FTP server is not available, how to set the status in DB table to 'error'
Yes Vlad you are right, this will avoid another DB connection created in Error Handler.
I hope this will provide some lights on the usefulness of "Transaction"
Edited by: RK.. on 27/03/2013 17:10