Skip to Content
avatar image
Former Member

Problem in back to back interface calls using JDBC adpater

Hi,

I am facing a problem while using the JDBC adapter from XI to oracle for back to back iterface calls.

as my scenario is as follows i am doing synchronus call with the first interface which is working fine, immediately after the synchronus call i am doing a asynchronus call which is showing as successfull in XI but it is not at all reaching to oracle side as it is supposed to update a table in oracle using a stored procedure.

any idea what could be the problem?

Shravan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 20, 2006 at 11:09 AM

    Hi Shravan,

    It would be helpful if you could tell us the error thrown

    by your JDBC adapter in the <b>RWB--> ADAPTER MONITORING</b>.

    Also, if possible can you give us the message being passed to your JDBC adapter.

    meanwhile, just check your JDBC adapter document format against the formats in this link.

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    For execution of a stored procedure using JDBC adapter, make sure that the action attribute is

    <b>EXECUTE</b> and the table name provided is the name of the STORED PROCEDURE.

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavesh,

      The document format is correct, and iam passing Execute parmater only.

      the problem here is i am unbale to access the Adapter Monitoring due to some problme in our landscape.

      but when i checked in SMXB_MONI it shows successfull till the end of message, this is just FYI.

      can you let me know even though the Adpater Engine falls into error will the message shows as succesfull in SXMB_MONI?

      Shravan

  • Feb 20, 2006 at 11:52 AM

    //can you let me know even though the Adpater Engine falls into error will the message shows as succesfull in SXMB_MONI?

    Yes..

    The adapter engine or JDBC adapter runs on your j2ee engine and the message displayed in SXMB_MONI is your message flow in the Integration Engine which runs on the ABAP stack.

    So, if there is an error in your Adapter, it will not be reflected in SXMB_MONI as the task of the Integration Engine is to just pass the message to the corresponding ADAPTER.

    So, I would suggest that you try to trace the error in your Adapter Monitoring as this could tell you the reason of your problem

    Hope this info helps,

    Regards,

    bhavesh

    Message was edited by: Bhavesh Kantilal

    Add comment
    10|10000 characters needed characters exceeded