on 09-21-2014 6:32 AM
What is "Persistence and Conflict Resolution" in JDBC Adapter. And why should we implement this?
I searched for this over the web, but couldn't get any good explanation.
local :
As in the other adapters, Exactly Once messages are handled by default using status information in the J2EE server. All adapter error statuses and program terminations initialized externally are also handled in this mode.
However, this does not include external program terminations during a database commit. In this case, the status of message processing is unclear since it can only be changed once the database commit has been completed.
However, this kind of situation is identified when the application is started and editing of the message terminated during processing can be controlled using Conflict Resolution.
This specification is only effective for handling errors that occur when a message is being processed for a second time after initial processing remained in the unclear status described above.
Conflict Resolution
· Error
If an error occurs when processing again, this is reported to the caller system when Error is selected.
· Redo
However, if the error occurs because the message was saved in the database when it was first processed and it is still located there, processing can be completed for the sender system using the value Redo (note that the database interface normally triggers the error duplicate insert if at least one of the table fields was defined as a primary key). Otherwise the sender system will continue to send the message and the error will continue to occur.
database:
Nevertheless, there is still a gap in Exactly Once processing: if there is no primary key field in the database table or if the data is already being processed by another application and it is then deleted, when the first attempt at message processing is interrupted by an irregular termination of the J2EE server immediately after the database commit, a message can be duplicated.
This problem can only be solved if message processing and status information management take place in the same database so that the processing steps have the same commit cycle.
In the database where the write-to tables are located you must create an additional table with two columns for this purpose. To define the table, specify the following:
· Database Table Name
Specify the name of the table.
· Key Column Name
Enter the key in this table column.
· Value Column Name
Enter the key value in this table column
check the below link :
http://help.sap.com/erp2005_ehp_03/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please, see this link:
Alternatively, You can see this other link:
Configuring the Receiver JDBC Adapter - SAP XI: Runtime - SAP Library
I hope to help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.