receiver JDBC communication channel

[Former Member]

Hi,

when I am trying to do UPDATE_INSERT in the receiver communication channel simultaneously for four tables, the error which I am getting is Violation of PRIMARY KEY constraint 'PK_CUSTOMER_RUOLO_PARTNER'. Cannot insert duplicate key in object 'dbo.CUSTOMER_RUOLO_PARTNER'.

could anyone help me out with this.

thanks.

[Former Member]

did u gave "UPDATE_INSERT" for action Attribute in Message Type of the Receiver Message Mapping???

[prateek]

The jdbc payload has already inserted some data with some key. Ur key value is either not present or is not properly recognized by the receiver system. Therefore it is trying to insert the record which u may wish to update.

Regards,

Prateek