Skip to Content

JDBC Receiver updation query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 28, 2015 at 04:46 PM

    Entire payload will fail.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2015 at 05:27 PM

    Hello Lavanya,

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

    Add comment
    10|10000 characters needed characters exceeded