Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 22, 2008 at 09:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2008 at 09:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2008 at 09:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22, 2008 at 09:35 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 05:19 AM

    Need some clarifications

    Add comment
    10|10000 characters needed characters exceeded