JDBC Insertion Response

[Former Member]

Hello everybody,

I have the next scenario:

R/3 IDOC -> XI -> Oracle JDBC Insertion

the problem is that the database is returning the reponse of the insertion and the idocs are asynchronous, so XI gives an error of mapping cause I can't map a synchronous interface to a asynchrounous one, can anyone help me with this problem any suggestions?????

Thanks in advance,

Regards,

Julio Cesar

[Former Member]

Thanks for the links.

[Former Member]

OK so maybe what I should try is a BPM with a sync-async bridge, can anyone help with some documentation on how to do this, maybe a blog, thanks in advance.

Regards,

Julio Cesar

[Former Member]

Hi,

Yes, you can go for Synch Async Bridge. Please refer to the links below

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

https://www.sdn.sap.com/irj/sdn/weblogs?log=/pub/wlg/1134http [original link is broken] [original link is broken] [original link is broken]://www.riyaz.net/blog/index.php/2008/04/16/a-step-by-step-guide-to-bpm-asynch-sync-bridge/

Thanks

Amit

Reward points if answer is useful

[Former Member]

Hi,

If you want pass the data from IDOC to Oracle database to update the information of Oracle table,it is possible.

see this for sample weblog....

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

For target JDBC structure see the following weblog...

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

and also refer

Thanks

Vikranth

[Former Member]

Hi,

IDOC's are Asynchronous. What are you expecting to get back and how IDOC will handle it?

You can't use IDOC in this scenario. You need to write a Client Proxy or Custom RFC which will post the data to XI and will get a response back from jdbc.

Thanks

Amit

Reward points if suggestion is useful