Integration Platform Technologies: Siebel eBusiness Application Integration Volume II > EAI Siebel Adapter > EAI Siebel Adapter Concurrency Control >

Modification Key

A Modification Key is an Integration Component Key of the type Modification Key. A Modification Key is a collection of fields that together should be used to verify the version of an integration component instance. Typically, Modification Key fields are Mod Id fields for the tables used. Multiple Modification Key fields may be needed because a business component may be updating multiple tables, either as extension tables or through implicit or explicit joins.

EAI Siebel Adapter methods (Insert, Update, Synchronize, Upsert) check for the existence of a Modification Key. If no Modification Key is specified in the integration component definition, or if Modification Key fields are not included in the XML request, the EAI Siebel Adapter does not check for the record version and proceeds with the requested operation. If a valid Modification Key is found, but the corresponding record can not be found, the EAI Siebel Adapter assumes that the record has been deleted by other users and returns the error SSASqlErrWriteConflict.

If a valid Modification Key as well as the corresponding record can be found, the EAI Siebel Adapter checks if the Modification Key fields in the XML request and the matched record are consistent. If any of the fields are inconsistent, the EAI Siebel Adapter assumes that the record has been modified by other users and returns the error SSASqlErrWriteConflict. If all the fields are consistent, the EAI Siebel Adapter proceeds with the requested operation.


 Integration Platform Technologies: Siebel eBusiness Application Integration Volume II 
 Published: 18 July 2003