12c SOA DB adapter polling Max raise size and Max transaction size issue

Srinanda Das

    Hi,

    I am trying to poll 100 rows per polling interval (60 sec) but Its polling all the rows >300 at same time.Can you kindly check and help on this what configurations i need to do to poll 100 rows per 60 sec basis.

     

    Please help.

     

    JCA activation spec details used:

     

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

          <property name="DescriptorName" value="DB_EmployeeLifeCycle_Event_PollingAdapter.EmployeelifecycleEvent"/>

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

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

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

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

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

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

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

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

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

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

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

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

        </activation-spec>