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?