skip to main content
Using the JDBC Client : JDBC Connection Properties : LongDataCacheSize
 

LongDataCacheSize

Description

LongDataCacheSize={-1 | 0 | x}. Determines whether the JDBC Client caches long data in result sets (images, pictures, long text, or binary data).

Valid Values

-1 | 0 | x
If set to -1, the JDBC Client does not cache long data in result sets. It is cached on the server. Use this value only if your application returns columns in the order they are defined in the result set.
If set to 0, the JDBC Client caches long data in result sets in memory. If the size of the result set data exceeds available memory, the JDBC Client pages the result set data to disk.
If set to x, where x is a positive integer, the JDBC Client caches long data in result sets in memory and uses this value to set the size (in KB) of the memory buffer for caching result set data. If the size of the result set data exceeds available memory, the JDBC Client pages the result set data to disk.

Default

None

Data type

String