Dynamic Query Selection at JDBC Receiver
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
Bhavesh Kantilal replied
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"