on 09-22-2008 10:16 AM
Dear Freinds,
In the current project i am working R/3 & Oracle based application .
Integration has to be done between R/3 and Legacy system which is running on Oracle.
Sender PROXY (Syn) -- Receiver JDBC (Asyn)
A single field from R/3 table has to be sent to the client's Legacy System. Based on that field, further information has to be retreived from 2 tables (from Oracle DB) and send it back as response.
For receiving the response back from the legacy what type of Comm channel is required.
If sender side Proxy is Synchronous and JDBC receiver is Asyn, what all do i need for getting response back.
Thanks & Regards
K. Ramesh
Hi,
Not sure why you need the Receiver to be Asynch?
In your case if I understand right, your sender is a proxy which is synch and receiver a JDBC.
Also, you need to pull some data from the Database depending on the Proxy input and then map it back to the Proxy response.
if this is the case, you can make a synch call to the database and this will pull the records from the database and this can be mapped to the proxy response as needed.
For info on how to use a Synch Select with proxy, refer to my blog " Receiver JDBC adapter - Synchronous Select Step by Step"
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you please clarify on using (Synch) JDBC receiver. The response of this will be mapped to Proxy response which has its own Data Type, Message Type & Message Mapping.
My doubt is why i need to put Sender Proxy as Synchronous. If i keep Proxy Sender as Synch then how will i get the response back from JDBC response.
Thanks & Regards
K.Ramesh
Hi,
>>My doubt is why i need to put Sender Proxy as Synchronous. If i keep Proxy Sender as Synch then how will i get the response back from JDBC response.
Why because if your sender Requests the Response back(Sync) then only the receiver will be able to send back.
Untill and unless the sender requests the response back, the receiver not able to send back.
Thats why we shld make the Sender Proxy as Sync inteface.
In the JDBC side we have to follow specific Response Structure to fire the response back to Sender.
Check my Above Reply & other replies as well on this
Regards
Seshagiri
Need some clarifications
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
>>Sender PROXY (Syn) -- Receiver JDBC (Asyn
Are you using any BPM for it?
If you really need responce from JDBC then you have to make JDBC as Synch.
But Message Strucutre for JDBC Synch receiver is little bit differenct, so have a look on Bhavesh blog. [JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928] [original link is broken] [original link is broken] [original link is broken];
Thanks
Farooq
Edited by: Farooq Farooqui on Sep 22, 2008 3:02 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this on Detailed RFC--XI-JDBC Sync Process
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.