Integration

Hi,

We have OSB DB Adapter poller with below jca configuration. We have earlier tried 'SELECT FOR UPDATE SKIP LOCKED' as well.

Currently we insert a record with is_read column as 0 and poller is supposed to read same and send it to destination once and make to column value as 2.

But here it is sending 100 plus times (sometimes 400+) to destination and then marks column value as 2. Please help to resolve the same.

  <property name="PollingStrategy" value="LogicalDeletePollingStrategy"/>

      <property name="MarkReadColumn" value="IS_READ"/>

      <property name="MarkReadValue" value="2"/>

      <property name="MarkUnreadValue" value="0"/>

      <property name="PollingInterval" value="5"/>

      <property name="MaxRaiseSize" value="1"/>

      <property name="MaxTransactionSize" value="5"/>

      <property name="NumberOfThreads" value="1"/>

      <property name="ReturnSingleResultSet" value="false"/>

      <property name="MarkReservedValue" value="R${weblogic.Name-2}-${IP-2}-${instance}"/>