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
Expand all | Collapse all

jdbc adapter notification buffer tables

  • 1.  jdbc adapter notification buffer tables

    Posted Wed May 19, 2010 02:15 PM

    Can I store JDBC Adapter Notifications trigger query data on Buffer Tables in different database of different vendor than the DB they are monitoring?

    Will appreciate a response ! Thanks !!
    :slight_smile:


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


  • 2.  RE: jdbc adapter notification buffer tables

    Posted Wed May 19, 2010 04:45 PM

    If the triggers used to populate the buffer tables from the source tables can access the tables of a remote DB then yes. But you’ll need to use Basic Notification only (which I recommend anyway).

    That said, I think this is probably a bad idea as this will force the use of distributed transactions, which has a variety of implications.


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