1 Reply Latest reply: Mar 22, 2012 5:20 AM by user790116 RSS

    Database Adapter Merge Operation is not working wiht 3 tables.

      Hello All,

      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.