Problem with Merge in database adapter
Hi Everyone,
For my Bpel process I have the following:
1) File adapter
2) Receive activity
3) Transforms activity
4) Invoke activity
5) Database adapter
My Bpel process is working fine, no errors. It pick up the file ---> sends it to receive --> then transform the records --> then Invoke sends it to DB adapter to presist the records.
For the setting of my DB adapter, to preform an operation on my table I chose Insert or update option.
when running the same process multipul times my records in the table get duplicated. I dont understand why that is happening since I chose insert or update option in the DB adapter ??
How can I make my DB adapter overwrites the same records in the database if my file adapter picked up the same file that contains the same records ??
Thanks in Advanced,
AJ