I am having 3 tables : Headers,Lines and Customer. In the database adapter i am using the insert/update (merge) operation. All these 3 tables are related to each with Primary Key and Foreign Key relation under the same database adapter.
Issue : When i am trying to insert a new row, data is getting inserted successfully, but when i am trying to update the same row by , row is getting updated successfully for Header and Lines tables while for Customer table , it is every time inserting a new row, though there is no change in the Primary Key col.
Primary Key Details :
Header Table : OrderId,SourceSystem
Lines Table : OrderId,SourceSystem,LineNumber
Customer Table : OrderId,SourceSystem
Any suggestions are Appreciated.
More specifically, out of three tables, on tow tables adapter is doing update (which is correct) and on the 3rd table it is doing Insert. Here also update should happen as the primary key is not changing.