Violation of PRIMARY KEY constraint in JDBC receiver

[Former Member]

Hi Experts !

I am configuring a JDBC Receiver. I need to insert the records and if the same record is coming again i need to update the records in my database.So I have used action "UPDATE_INSERT". But now I am getting the error,

"Violation of PRIMARY KEY constraint-Cannot insert duplicate key in object " .. Pls help me out !!! It is very urgent!!

Thanks,

Laawanya

[Former Member]

Lawanya,

It seems that you are trying to update the primary key itself..

One thing is sure The error is related to data....

Do this at JDBC receiver Communication channel :

Under advanced option : use parameter "logSQLParameter" and use value "TRUE"...by this way you will be able to see the values passing through JDBC receiver .

And then check whether the same value exist in Table or not...

Feel free to ping for further clarification..

Regards,