Micro Focus Enterprise Developer 2.3 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > SQL Option User Guide > JDBC > Connecting to an XDB Server > Direct Flight Data Connection Properties > cache.fetch.size

cache.fetch.size

Properties:

Where it can be set:	In the URL or in a Properties Object
Possible Values:	Integer (representing the number of bytes) or -1 (disable limit)
Default:	8196

Comments:

Do not disable both cache.fetch.numrecs and cache.fetch.size. At least one of these properties must specify a limit. When both limits are enabled, the Direct Flight driver uses the smaller limit.