on 01-08-2016 7:11 AM
Hi Jhon,
No, there is not the way to work with sender jdbc. Sender JDBC do a poll, in this way the sender jdbc do a select based in a flag field/s and later in the next step do an update (in UPDATE SQL STATEMENT) in that flag fields.
Kindly, you can tell us your entire scenario and we can help you better. You can do a RFC -JDBC scenario (SAPTechnical.COM - A Step-by-Step Guide on Asynchronous RFC - to – JDBC Scenario Using SAP PI 7.0) or proxy abap, inside abap do the RFC call and later call the PI and to update in JDBC.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks very much!
The thing is like this:there is a interface user adapter JDBC->RFC .SAP access/select data stored in Oracle DB ,and update flag of the line of data the same time,like the picture above.it means SAP have readed this data,so is there any way to update flags according data what sap read !
Can this interface become Synchronize ?
Please,Thanks!
Hi John,
I think you would need three states for your flag, N "Not selected", S " Selected", U " Treated by SAP". Therefore you can udpate to S in the poll (in this way you can avoid to select always the same register in a issue case), later you can have these options:
1. Do a RFC lookup in a jdbc-jdbc scenario (Defining RFC Lookups Graphically - Enterprise Services Repository - SAP Library). At mapping level you can call to SAP.
2. To do async/sync bridge without ccBPM. You can a JDBC-RFC-JDBC scenario in one shoot, check this similar example: File RFC File using request response beans without BPM - Netweaver Technology - SCN Wiki. You can notice in the sender channel using module beans you can send the request to a sync RFC interface.
Hope this helps.
Regards.
Thanks!
Yes,Sure,we have two states for flag,0-'Not Selected',2-'selected'. And we also update to 2 after selected, but there is one issue case: WMS also insert data into DB when SAP select data from DB! The result is what SAP updated data is more than SAP selected !
Because of this, We want to know is there any way to avoid this situation ! Or,is there any way to know what data are we selected,and then update this data!
Regards!
Hi John,
the result is what SAP updated data is more than SAP selected !
I think you have to select the DB table key values to do the after right update. If this key values are not unique, may be you should talk with the DB team to create an auto-count field in order to have a unique key field.
Regards.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.