Maximum Rows in Select JDBC Operations defaults to 1000

pranav.gandhi.6767 · October 13, 2006, 3:52am

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

gupta_r.17495 · October 13, 2006, 4:36am

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

Topic		Replies	Views
JDBC Adapter 602 build 443 limited to 1000 rows webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	6	1468	April 2, 2021
Resultsets from Stored Proc using WmJDBCAdapter webMethods , Integration-Server-and-ESB , Flow-and-Java-services	3	1249	April 2, 2021
change adapterconnection settings in runtime - maximum row webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	3	1371	April 2, 2021
Adapter defaults the values to Null webMethods , Integration-Server-and-ESB	1	1363	April 2, 2021
Maximum row property in JDBC adapters webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	617	April 2, 2021

Maximum Rows in Select JDBC Operations defaults to 1000

Related topics