Skip to Content
avatar image
Former Member

Java Client - XI - Oracle Database (Asynchronous with an acknowledgement)

Hi All,

I have a requirement, where Java client sends an asynchronous message to XI and XI inserts/updates the data in Oracle database using JDBC receiver adapter. Here I want to send an acknowledgemnet back to Sender system that the message has been successfully processed in the database.

Can I achieve this without using BPM?

If using BPM then how do I configure my BPM?

Also, I want to know for insertion or updation of data, does Oracle database sends a response on successfull processing?

Your help would be appreciated.

Ashish.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 26, 2007 at 11:38 AM

    Hi ,

    Jdbc Adapter supports synchronous application.It will give the response automatically with the statement tag.

    <statement_response>

    ...

    <statement_response>

    If you want to the response at the sender make your outbound interface as synchronous .Check the below link.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f272165e-0401-0010-b4a1-e7eb8903501d

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26, 2007 at 11:40 AM

    Ashish,

    I have a requirement, where Java client sends an asynchronous message to XI and XI inserts/updates the data in Oracle database using JDBC receiver adapter. Here I want to send an acknowledgemnet back to Sender system that the message has been successfully processed in the database.

    Can I achieve this without using BPM?

    No. thene you need to make ur scenario synchorouse.

    If using BPM then how do I configure my BPM?

    in send step use acknowledgement check box

    Also, I want to know for insertion or updation of data, does Oracle database sends a response on successfull processing?

    yes but if you make ur jdbc receiver adapter sychronouse

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26, 2007 at 12:01 PM

    Ashish,

    This is possbile without a BPM. JDBC receiver adapter supprots synch processing. It returns the status of the operation you have attempted.

    In your case, make the call from the Java Application a Synchronous call to XI. Make the synchronous call then to the Database using the Receievr JDBC adapter. Map the JDBC response to the Format of the response expected by your sending application.

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Ashish,

      Not sure I get the entire flow.

      You Java APP sents data to XI and XI needs to insert the data into the database.

      Before the next round of data is sent by the Application, Xi should sent back info on the status of the records.

      Is this what you want?

      This will be like I have pointed earlier possible without a BPM. But, make the call from the sending application Synchronous. And then map the JDBC response to the calling aplication.

      If i got the requirement wrong can you let me know in more detail, what is it that you are trying?

      Regards

      Bhavesh

  • avatar image
    Former Member
    Feb 26, 2007 at 11:30 AM

    Hi Ashish,

    Please go through the below link.. It will help you.

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

    It shows how to get response from a JDBC receiver...

    Hope it helps you.

    Regards

    Kiran..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26, 2007 at 12:14 PM

    HI,

    Without BPM it can be possible..

    See the below example scenarios for JDBC Response.

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

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/content.htm

    Regards

    Chilla..

    Add comment
    10|10000 characters needed characters exceeded