Guaranteeing sequence order when polling with DB adapter
500170Apr 12 2007 — edited Apr 13 2007We need to read rows from a source table using the DB adapter in polling mode, and deliver them to separate files in the same order they were read from the DB.
My understanding is that when polling, if we find 10 records to be processed, 10 separate BPEL processes will be created.
It's not clear how to then maintain the sequence order when creating the files, as each process may execute faster or slower than others.
Any advice appreciated
Toby