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.


#TechXchangePresenter
 View Only

  • 1.  Is XMLTYpe supported?

    Posted Wed July 02, 2014 01:15 AM

    Hi All,

    We are using webMethods 7.1.3 and also planning to upgrade to webMethods 9.5.1

    We are using Database as Oracle 11g and JDBC adapter 6.5 with JDBC_6-5_Fix25.

    I could not find this information anywhere though. Is XMLType supported by JDBC adapter in any of the versions?

    I tried in 7.1.3 and eventhough the select statement picks up XMLType as the column type, the service just hangs.

    If not, what workaround is possible?

    Thanks and Regards,
    Ninad Patil


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


  • 2.  RE: Is XMLTYpe supported?

    Posted Wed July 02, 2014 06:37 AM

    Ninad,
    I suggest to check with SAG Global Support…

    Did you try with java.lang.String ??

    Please let me know if you get some information on this.


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


  • 3.  RE: Is XMLTYpe supported?

    Posted Thu July 03, 2014 05:57 AM

    Hi Ninad,
    XML type is supported from Java 1.6 version. Cross check what version of Java you are using
    Make sure the driver you are using is of Type 4 driver files. If not, use the appropriate .jar file

    As you are in 7.x version, if you are not in Java 1.6, you have to convert the XML type to a VARCHAR using stored procedure or some other way, and then perform Insert.

    HTH
    Senthil


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


Related Content