skip to main content
Connection property descriptions : BulkPageSize
  

Try DataDirect Drivers Now

BulkPageSize

Purpose

Specifies the maximum number of records to be fetched from Oracle Eloqua in a single request.

Valid Values

x
where
x
is a positive integer between 2 and 50000.

Notes

*Generally, higher page sizes return results more quickly. However, Oracle Eloqua imposes a 32 MB limit on response package size. If queries return large records, too many records within a single page will exceed that limit, causing the query to fail.
*All of the objects returned within a page must be materialized as the page is retrieved, so sufficient Java heap space is necessary with large page sizes containing many small columns.

Data Source Method

setBulkPageSize

Default

5000

Data Type

Int