| Sanket 2006-05-20, 1:13 pm |
| Hi All,
I am polling a table to collect a set of records and the splitting them
into invidual records using splitter pattern. Now, I need to send this
individual record to another orchestration but before that I want to
update the DB to change the status of the record so that the SQL
adapter does not pick the record again with next polling activity. I've
created a schema for the individual record and I am using 'Add
Generated Item' for updating the record.
Now, the problem here is, the mapping from Individual Record Schema to
Updategram Schema is not working. I've put in a test send adapter to
see if transaltion is correct and is generating 0 kb files.
I am using different target namespaces for each of the schemas.
Also, Is there any better way of doing it? Can anybody let me know
whether SQL adapter supports CheckPoint?
PLESAE HELP!
|