on 12-04-2008 3:31 PM
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
Why are you using a stored procedure?
The select and update statement are part of the JDBC sender.
The JDBC sender will only flag the records in the DB after they have been received in XI...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am using Stored Procedure because the are too many rows inside the table and every second new rows are added. So the stored procedure is going to sum the rows and send it that way to PI. Also the R3 side is going to have it easier this way.
-
Hi Bhavesh,
I am not updating the flag. the stored procedure is going to do this. There is were the problem lies. Is it possible that I cant receive the data BUT the stored procedure is updating the fields?
The select and update query are updated in a single atomic transaction and you can be rest assured that XI takes care of this implicitly.
Check the JDBC adapter FAQ on service market place for more info!
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.