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

  • 1.  Jdbc adapter output type

    Posted Fri August 26, 2005 09:00 AM

    Hi
    i am facing a problem with the jdbc Custom sql adapter service. The database has fields with varchar2(24bytes) as the datatype.I am not able to retrieve that data with such fields to the webMethods environment. Can any one help me as to how to retrieve such data to the webMethods?

    Thanks in advance


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


  • 2.  RE: Jdbc adapter output type

    Posted Fri August 26, 2005 02:55 PM

    can you state your SQL statement ?


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


  • 3.  RE: Jdbc adapter output type

    Posted Fri August 26, 2005 11:09 PM

    Pavan,

    You should be able to get this data as a string in webMethods. Make sure your Output JDBC type is set to VARCHAR and Output Field Type is set to java.lang.String in your adapter service.


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


Related Content