Skip to Content
avatar image
Former Member

JDBC sender Advanced Options

Hi All,

We have a JDBC sender scenario where PI reads data from database and retrieve records which are having process_flag '0' and update it to '1' after picking. In few instances we could observe that PI had picked the records and updated to 1 where at the same instance database went down and we could observe that all records are not pushed to PI and those have been updated to 1 at sender end. Can we have any additional setting to avoid dataloss?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 31, 2017 at 11:31 AM

    Hi Vikram,

    Use isolation level read_committed in the advance tab and try .

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded