Skip to Content
avatar image
Former Member

JDBC-SOAP synchronous scenario...how to convert soap xmk repsonse to JDBC format

Hi experts

I have a scenario where a sender JDBC adapter is going to all SOAP webservice to create/update/delete user and receive response data that is to be fed in receiver JDBC adapter synchronously.

i have seen this scenario https://blogs.sap.com/2013/12/04/jdbc-to-jdbc-synchronous-scenario-with-rr-beans-and-without-bpm-and-rfc-lookup/

where a request response bean and response one way bean is used to call the receiver JDBC channel.

but my question is how it will work in SOAP receiver case as it will return response in XML format and JDBC reciver won't be able to receive this data and feed back in tables.

I also SOAP lookup can be done between JDBC-JDBC scenario but that will be monitoring issue for SOAP

any help is appreciated.!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 24, 2017 at 07:11 AM

    Hi Naina!

    Hi Naina!

    Please refer to this blog:

    https://blogs.sap.com/2014/01/28/generic-pi-async-sync-bridge-configuration-for-any-adapters/

    You don't use any modules in JDBC sender channel. In SOAP receiver channel you use RequestResponseBean bean before calling standard

    module to change message's delivery semantics to BestEffort (synchronous mode) and after standard module you insert ResponseOneWayBean bean (change delivery semantics to EO) with parameters defining asyncronous sender interface/namespace. And for that asyncronous outbound interface you create the second ICo. Interface uses the web service response message type as Request message type. Thus, you have the second ICo - asynchronous web service response to asynchronous JDBC receiver interface.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

    • Please read above mentioned document carefully:

      Asynchronous outbound response interface of the receiver (#4) –> Asynchronous inbound response interface (#2) :

      1. The sender communication channel must be an asynchronous sender. In this example, it is an asynchronous SOAP sender communication channel.

      Yes, you need sender async channel and receiver async channel for second ICo.

      Regards, Evgeniy.

  • Jul 18, 2017 at 06:53 AM

    Hi Naina!

    May be I don't understand your question right, but there is nothing special in this scenario.

    You use async-sync bridge, in request mapping you transform JDBC message to SOAP request and in response mapping you transform SOAP response to JDBC message format and send it to receiver JDBC adapter.

    Please refer to SAP help:

    https://help.sap.com/SAPHELP_nwpi711/helpdata/en/48/465581929734d9e10000000a42189d/frameset.htm

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded