0 Replies Latest reply on Oct 20, 2018 8:08 PM by DasN

    12.1.3 database adapter to process 25k records

    DasN
    DasN Oct 20, 2018 8:08 PM

      Hi All,

       

      Seeking your expert advice on the best approach to handle the below scenario.

       

      I am using 12.1.3 version SOA suite.

      I have a BPEL process which is scheduled to run on a daily basis.In that my database adapter is running a select query on a database and expects around 25 k records which then needs to be pushed to down streams.My two key points...

       

      1.records are in sequence so needs to be processed in sequence

      2.I have to update a water mark with the last record processed on a day.

       

      What is the best approach to handle this scenario.I have to do this using SOA suite only.

       

      My current approach is I am putting a maximumm number of record read (say 500) in database adapter and call my BPEL process again from within the flow to process next 500 and so on.

      In this way I am maintaining the sequence and watermark as well.

       

      Is there any better way to handle this scenario?

       

      Thanks

      ND