IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

How Oracle clean up buffer table for insert notification ope

  • 1.  How Oracle clean up buffer table for insert notification ope

    Posted Tue March 04, 2003 08:57 PM

    I have Oracle (Intelligent) running - 4.1.1 with wM Ent Broker 5.0.1. I configured an insert notification operation to select all the columns when 2 of the columns (say A and B) are not null. I notice that the buffer table that oracle adapter automatically created behind the scene is populated everytime a new row is inserted regardless of whether or not the column A and B are Null or not null. Then the rows with A and B not null will then get published. However the rows that didn’t meet the condition stays in the buffer table.

    My question is when will those rows get deleted? Will they ever get deleted?

    Thank you.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: How Oracle clean up buffer table for insert notification ope

    Posted Fri March 07, 2003 08:32 AM

    Did you use for publishing documents inside your integration component a PUBLISH or OUTPUT step?

    I experienced a similar problem. I solved it substituting the PUBLISH step with the OUTPUT step.

    Let me know if it works also for you.

    Bye,
    Nello


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content