on 06-13-2007 2:49 PM
Hi
I want to make a synchronous call to MS SQL Server.
There are two conditions to be satisified.
1. Either all records has to be updated or nothing should be updated.
2. A response message has to be send back to R3 to show it in the Sender application
How can i achieve all or none and send a proper response back. to R3
I can use a file scenario also and achieve all or none. But the response back has to be send synchronously.
Please suggest a solution or a work around for this problem
Thanks
Sebin
Hi Sebin,
>>>Either all records has to be updated or nothing should be updated
This is standard
>>>
2. A response message has to be send back to R3 to show it in the Sender application
You will get a response message with no of changed rows. In case of exception use fault message, which you map back to ERP.
Regards,
Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Go through this
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter
Regards
Hemant
If find helpful plz award points
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.