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

JDBC Adapter 46 Stored procedure call

  • 1.  JDBC Adapter 46 Stored procedure call

    Posted Fri September 26, 2003 08:14 PM

    Does anyone have an example of what the stored procedure should look like when called from the JDBC Adapter 4.6 (Enterprise Server 5.0)

    I haven’t been able to find any documentation on this. I’ve found it for the Oracle Adapter, but not the JDBC Adapter!

    Whenever I try to call my stored procedure, I always get an error that says the wrong number or type of parameters is being passed.

    Thanks in advance for any help!


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


  • 2.  RE: JDBC Adapter 46 Stored procedure call

    Posted Tue March 09, 2004 09:00 PM

    Hi Kevin,

    At the time we had a similar integration, we were using the JDBC Adapter to connect to an AS/400. But there was a bug with the JDBC Stored Procedure Call Operation. So instead, we configured a Scripted Operation with a custom step. In the custom step, we used java code to call the SP.

    Unfortunately, I don’t have a copy of the actual SP. But if you want to know more about the java calls we used, let me know.

    Cort


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


Related Content