Integration

Hi Guys,

I have a requirement in SOA 12c to poll 10 records at a interval of 10 seconds from a table. Below are the property specifications of my JCA file:

  <endpoint-activation portType="PollBrokerAgentRecordsCDHDB_ptt" operation="receive">

    <activation-spec className="oracle.tip.adapter.db.DBActivationSpec">

      <property name="DescriptorName" value="PollBrokerAgentRecordsCDHDB.MoveCdhUdhDataTransfer"/>

      <property name="QueryName" value="PollBrokerAgentRecordsCDHDBSelect"/>

      <property name="MappingsMetaDataURL" value="PollBrokerAgentRecordsCDHDB-or-mappings.xml"/>

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

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

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

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

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

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

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

      <property name="SequencingColumn" value="EVENT_KEY"/>

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

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

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

    </activation-spec>

  </endpoint-activation>

The problem is when we have suppose 400 records as unprocessed in the table ,adapter picks up 10 records at a time and we have 40 different instances in em console but they all are picked at same time and that's where I have the issue its not polling at a interval of 10 seconds.

Any help would be apprceiated.

Regards,

Jaya Hasija