JDBC sender Advanced Options

[vikramanne]

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?

[apu_das2]

Hi Vikram,

Use isolation level read_committed in the advance tab and try .

Thanks,

Apu

[vikramanne]

Thanks for your thoughts Apu currently i have serializable let me try with read_committed.