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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

Notification to read XML from an Oracle table

  • 1.  Notification to read XML from an Oracle table

    Posted 02/12/09 05:25 PM

    I’m running webMethods 7.1.2.

    I want to use a JDBC Adapter Notification to read a large XML document contained in an Oracle CLOB field, convert this to a document (using xmlStringToNode and xmlNodeToDocument), then publish this document.

    I just discovered that JDBC adapter notifications do not support CLOB fields.

    I’m thinking that I’ll follow the JDBC Adapter Notification with a JDBC SelectSQL adapter service to read the record again to extract the XML data stored in the CLOB field, then do DeleteSQL to delete the record.

    Is there a simpler way to accomplish this?

    Thank you,

    Scott


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


Related Content