Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Query Selection at JDBC Receiver

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

Former Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question