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
Back to discussions
Expand all | Collapse all

java.sql.Clob is not visible in Adapter service

  • 1.  java.sql.Clob is not visible in Adapter service

    Posted Tue March 08, 2011 08:39 AM

    Hi all,
    I have Storeprocdure which takes the CLOB as input, Created a adaper service to call the SP. But the Input parameter “Input Field Type” is getting set to java.sql.Struct instead of java.sql.Clob.
    In the drop down to change the input type filed also the Clob is not listed(Pls refer the attachment). Can some one help me on this.

    This is what I have in IS admin console: - Adapters > JDBC Adapter > About
    JDBC Adapter Version: 6.5
    Updates:JDBC_6-5_Fix25 WmJDBCAdapter_JDB_733
    Adapter_Clob.jpg


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


  • 2.  RE: java.sql.Clob is not visible in Adapter service

    Posted Fri July 24, 2015 06:42 PM

    Is this issue resolved?javascript:void(0);


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


  • 3.  RE: java.sql.Clob is not visible in Adapter service

    Posted Sat July 25, 2015 06:47 AM

    Your JDBC adapter is lacking a fix level. What is your current installed fix level?


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


  • 4.  RE: java.sql.Clob is not visible in Adapter service

    Posted Mon July 27, 2015 02:20 PM

    Which wM Version are you using?

    You should at least update to Fix45 or newer.

    If you are using wM 9.0 or newer you might consider an upgrade to Adapter for JDBC 9.0.

    Regards,
    Holger


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


Related Content