Skip to Content
0

JDBC sender Advanced Options

Mar 31, 2017 at 01:46 AM

54

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Apu Das Mar 31, 2017 at 11:31 AM
0

Hi Vikram,

Use isolation level read_committed in the advance tab and try .

Thanks,

Apu

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0