sender JDBC - options other than flagging

[Former Member]

Hi Experts,

I need to know the options available in sender JDBC channel to prevent the records to be read twice.

I know that flagging is an option where we use update statement post reading to change the flag to 1.

Kindly let me know all the other options.

For example the database may not have any suitable/free column to update after the table is read.

Thanks,

John

[Former Member]

Hi,

As per my knowledge, there are 2 options:

1) Update statement available in Sender channel

2) Use of custom JAVA module, it can help to flag the data as soon as they are read by channel. But this involves the development of such a JAVA module which are extra efforts.

-Supriya.

[Former Member]

Hi Supriya,

Both your options achieve only flagging a column, which I am aware.

Do we have any other options other than flagging if such a column is not provided by the JDBC team.

Thanks,

John