JDBC Receiver updation query

[former_member188885]

Hi All,

I have a File to JDBC scenario. PI is using a Insert statement to update the staging table in receiver end. The initial requirement was to used INSERT statement and not UPDATE_INSERT.

At times when the payload is being sent to the staging table, the messages are failing due to Unique constraint error. But the records in the payload are unique. Few of the records in the payload are existing in the table and hence failing. My doubt here is when the payload contains one record which is already existing in the table, will the entire payload fail or just the one duplicate record?

Thanks,

Lavanya R

[former_member186851]

Hello Lavanya,

Entire payload will fail,I would suggest to go with Update_Insert.

[Former Member]

Entire payload will fail.