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

[Former Member]

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.

[Former Member · Accepted solution]

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-e7e...

Regards,

[Former Member]

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..

[bhavesh_kantilal]

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

[Former Member]

If some <b>N</b> records needs to be inserted / updated, then my sender system has to wait till the processing is done, thats why I want this scenario to be asynchronous and acknowledgement should indicate that the processing is done successfully.

In, without BPM case, Alerts could have been configured but it gives only Transport acknowledgement and no Aplication acknowledgement.

I think, using BPM is the only way an application acknowledgement can be sent. Do you have any other thoughts?

Regards,

Ashish.

[Former Member]

Yes....You have to use BPM in this case.

[bhavesh_kantilal]

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

[Former Member]

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

[Former Member]

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..