Skip to Content
author's profile photo Former Member
Former Member

Scenario

Hi...All,

Is it posible to do the JDBC-RFC Synchronous (JDBC-RFC-JDBC) Scenario with out using BPM ?

if posible pls let me know the processing steps..

Thanks in advance,

Pasi.

Edited by: pasi s on Jun 19, 2008 9:28 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:44 AM

    HI,

    As far as I know you will not be able update the database back based on RFC response in a synchronous way though you have option of selecting BE in sender JDBC adapter.

    This is sentence from SAP training material...

    "In the case of a JDBC sender, the database table is queried via a SELECT statement. The message is by definition asynchronous hence the QoS should be set as EO or EOIO. "

    The only option i can think of is JDBC Sender(async)->BPM->RFC(synch)->response mapping to JDBC receiver structure->JDBC receiver to update the table.

    Also check these threads...

    jdbc-source-in-a-synchronous-bapi-call

    jdbc-sender-synchronously

    You can't use the JDBC sender adapter as Synchronous way, try to Choose the Quality of service : "Best effort" in your sender communication channel to create synchronous flow. You will get an error that this mode (best effort) is not allowed

    You have to go for BPM,

    Thanks

    Swarup

    Edited by: Swarup Sawant on Jun 19, 2008 9:45 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:37 AM

    Hi,

    you can configure jdbc- rfc with out BPM,

    when bothe message interfaces are sysnchronous.

    if you are planning jdbc as asynchronous.

    please use sync-asysnc bridge.

    you want example scenario, go through

    SAP Basis-> http://sap.com/xi/XI/System/Patterns->

    BpmPatternSyncAsyncBridge

    warm regards

    mahesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:38 AM

    hI,

    These links are useful to you..

    JDBC Sender/Receiver adapter

    /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

    http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

    Thanks

    Vikranth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:44 AM

    hi,

    For JDBC (Sender/Receiver )Scenario we have to Install the JDBC Drivers on XI Server.

    Use those Driver name and Connection in JDBC Adapter to connect to the Database.

    For RFC Sender Adapter we have to create the Program ID in SAP R/3 side.

    For RFC Receiver no need of any Extra settings.

    jdbc-rfc scenario

    JDBC-RFC Scnario mapping problem

    Step by step RFC to JDBC scenario

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

    Tips and Tutorial for Sender JDBC Adapter

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

    http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10

    Also you can look at this scenario File to JDBC:-

    /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

    /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

    /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

    SENDER RFC

    Registered server program name which is maintained in the ABAP should be called in the program ID.

    for more information follow this links

    /people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

    /people/shabarish.vijayakumar/blog/2008/01/08/troubleshooting--rfc-and-soap-scenarios-updated-on-20042009

    how-to-test-the-rfc-to-flat-file-scenario

    Check these threads, they contain solution to your scenario.

    jdbc-source-in-a-synchronous-bapi-call

    can-i-configure-jdbc-sender-to-process-the-rfc-res

    jdbc-sender-synchronously

    Link :http://help.sap.com/saphelp_nw04/helpdata/en/6f/1bd5b6a85b11d6b28500508b5d5211/content.htm

    https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1685 [original link is broken] [original link is broken] [original link is broken]

    Please go through the following links.

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step JDBC Receiver Adapter -- Synchronous Select Step by Step

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter Sender JDBC adapter

    Tips and Tutorial for Sender JDBC Adapter

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    For JDBC, use this weblog

    /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

    step by step RFC to JDBC scenario

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

    JDBC to XI to RFC

    JDBC --- >XI --->RFC

    JDBC TO RFC SCENARIO

    JDBC to RFC synch RFC call not executing.

    Thanks,

    Vijaya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 07:48 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.