Proxy(asynch) to JDBC(sync) to Proxy (asynch)

[Former Member]

Hi ,

I have a scenario where i'l be triggerin proxy(12 tables data) and will be either inserting or update to JDBC 12 tables and later shud recieve an acknowledgement of all the 12 tables and pass it to the proxy (updatng the 12 ztables field as sucess ) . can any 1 provide me a solution please .. or how to go about the scenario.kindly help

[former_member200962]

What is the acknowledgement that you are talking about...is it System ACK or Application ACK?....Application ACK not supported

Or is it a response message that you will be receiving from the JDBC?......ACK and response are different.

Regards,

Abhishek.

[Former Member]

Hi

I just need a response message from JDBC whatever tables are updated or inserted , so that i can update my ztables in abap side with status field of 12 tables updated to "sucess"...

and i'm curious to kno what are ACk msgs wil be sent by JDBC as soon as update or insert is done.

[Former Member]

can any one provide some inputs to proceed please

[Former Member]

Also on sender proxy, i would write a single Proxy program to gather all the data (from 12 tables).. Data of each table in a single record Qualified by its Table name or other table metadata details...

On the receiver end, I would write a Stored Proc to update all the tables & give the status of each of those as single output...

Receive them back & update the ABAP tables using proxy (metadata info of the tables is still obtained from the stored proc... which tables are success & which are failure)

-Siva Maranani

Edited by: Siva Maranani on Jul 23, 2009 11:56 AM