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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Maximum Rows in Select JDBC Operations defaults to 1000

  • 1.  Maximum Rows in Select JDBC Operations defaults to 1000

    Posted Thu October 12, 2006 11:52 PM

    Hi,
    The Maximum Rows in Select JDBC Operations defaults to 1000 for second Select Adapter Service onwards.

    The first Adapter Service has the correct default value of zero in the maximum rows which will retieve all the possible rows of the ResultSet.

    Is this a bug due to which the default is set to 1000 for Select Adapter Services?
    Does a fix exist for the same.

    Thanks,
    Pranav


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


  • 2.  RE: Maximum Rows in Select JDBC Operations defaults to 1000

    Posted Fri October 13, 2006 12:36 AM

    Basicall you have to change it to zero and save it.It might be the default value or could be a bug,we also did changed the value for some of the Select JDBC template services…Its extra work though…

    HTH,
    RMG


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