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

  • 1.  Error Creating Stored Procedure w/Signature

    Posted 01/14/09 03:09 PM

    Hi,

    A few week back the IS started to show the following error when creating an Adapter service - Stored Procedure With Signature.

    com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
    [ADA.1.320] Cannot get the list of stored procedures. "
    (17412) Bigger type length than Maximum"
    Bigger type length than Maximum
    on procedureSignature.colIndexes [Ljava.lang.String;@170376


    Note that I’m able to select the Procedure Name in the combo box, but once selected the error is display.

    Thanks.
    Francisco Pereira

    Any ideas why?


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


  • 2.  RE: Error Creating Stored Procedure w/Signature

    Posted 02/04/09 11:30 PM

    What version of the JDBC adapter is this? Do you have latest version of the JDBC drivers installed?


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


  • 3.  RE: Error Creating Stored Procedure w/Signature

    Posted 02/12/09 08:05 PM

    I change my driver to ojdbc14.jar and ocrs12.zip, and it started working correctly.

    Those are the jars recommended for my Oracle DB Version.

    Thanks


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


Related Content