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 601 Stored Procedure

  • 1.  JDBC Adapter 601 Stored Procedure

    Posted Thu April 03, 2003 03:26 PM

    I am trying to execute a MS SQL 2000 stored procedure from the webMethods JDBC adapter. I’ve set up the connection to the database, I’ve created the Adapter Service for the stored procedure.

    The catalog name seems to populate with the database, the schema name populates with the user and the procedure name populates with the stored procedure and that is where I am stuck.

    Does webMethods not query the procedure to look for the parameters, results sets, and return set fields? Do I have it input those myself? Is anyone out there executing a stored procedure that can give me some help?

    Thanks


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


  • 2.  RE: JDBC Adapter 601 Stored Procedure

    Posted Mon April 07, 2003 02:16 AM

    Yep…

    You have to input the parameter manually. At least for Oracle I have to set the inputs and output by myself.

    Sometimes when you have a lot of field to fill it is boring…


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


Related Content