Skip to Content
0
Former Member
Dec 04, 2008 at 03:31 PM

JDBC scenario doubt

16 Views

Hi,

I have a scenario but am not about the approach. I would appreciate it if you could share your ideas.

Scenario: We have a DB from which we are going to take data executing a Stored Procedure created at the DB side. Then we sent the data to R3 using ABAP Proxy

Solution: JDBC Sender is executing the stored procedure. the procedure select's the data, sent it, and flag it. PI takes it and sents it to R3 via proxy.

Problem: The problem here is what will happen if the connection is interrupted WHILE the procedure is executed. So that we dont get the data but the procedure flags the rows in the DB.

Can this happen? If yes how can I avoid it?

Thanks.

Arman