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

Resultsets from Stored Proc using WmJDBCAdapter

  • 1.  Resultsets from Stored Proc using WmJDBCAdapter

    Posted Fri May 14, 2004 01:38 PM

    I am using the JDBCAdapter to connect to a UDB 8.1 database. I am making a call to a stored procedure that returns 7 resultsets. In the Developer (6.01) I can only allocate 5 resultsets to be returned.

    Is there a way to bump up the maximum number? If not, does this limit exist in version 6.1 of Developer?

    If anyone has any insight to this, it would be greatly appreciated!

    Thanks!


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: Resultsets from Stored Proc using WmJDBCAdapter

    Posted Fri May 14, 2004 03:39 PM

    In the AdapterService panel under Select menu check if result count is set in the Maximum Row box.Actually this value should be set 0,so that all the results will be returned as expected.

    This is in Developer 6.01

    HTH,


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 3.  RE: Resultsets from Stored Proc using WmJDBCAdapter

    Posted Mon November 19, 2007 06:41 AM

    Hi,

    I have created Dynamic SQL for retrieving data from tables.
    and i want to use Maximum Rows option to limit the result sets. I set to 1000 for Maximum Rows. Its working fine.

    As per my requirement i have to get this maximums rows input from configuration files. I am not sure how to pass my input values to Maximum Rows filed. In webMethods 6.1, it is a select box. (not allowing to pass any dynamic inputs!)

    Please advise.

    Thanks!
    Arul


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


Related Content