cancel
Showing results for 
Search instead for 
Did you mean: 

Status Of Database Update from JDBC Adaptor

Former Member
0 Kudos

Dear all,

We have Proxy to JDBC scenarion, where in we will push the data from SAP ECC and update this in third part system. The sender proxy will be called from user exit. This user exit is automatically called when Production Order is saved. In the user Exit we have futher code to be executed depending on the status of Update. our requirement is to ge the status of update immedietaly so that production order creation shoud not be delayed.

The Failure in update may happen due to System failure or inconsistence in Data. How do we get acknowledgement in SAP ECC for such failures, please suggest.

Let me know if any clarification is required.

regards,

Raghavendra.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi

we can configure the receiver jdbc adapter in synchronous fashion , for getting the result on total number of updates in the database table by writing a stored procedure,or else we can handle it in PI7.0 version

regards

kummari

Former Member
0 Kudos

Hi,

For this you have to make the Proxy call as Sync from the SAP.

And in the JDBC side also you have to make the Interface as Inbound Sync.

For JDBC Response , we have specific structure needs to follow.

Once you execute the Proxy from R/3 in Sync mode, this will reach to JDBC and this JDBC will send the Response kind of message back to Proxy.

So that you can come to know the Response of that Dbase easily

Have a look at this Process , on how to configure

RFC-XI-JDBC Sync Process

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

Regards

Seshagiri