Problem:

Can you please ask for verification of the diffence between the following JDBC connection Properties ?

cache.numrecs

cache.fetch.numrecs

Resolution:

cache.numrecs = total number of records to prefetch. Unless you know the real amount of records you want I would leave this as the default of -1 no limit, For example, we will give you all the records that the query returns.

Cache.fetch.numrecs = total number of records to fetch on one batch of prefetches. (note many prefetches may take place per query) Increase this number to return more records per prefetch. Default is 100 per prefetch.