skip to main content
Part 4: The Connect XE Drivers : The Driver for Apache Hive : Connection Option Descriptions : Default Buffer Size for Long/LOB Columns (in Kb)
  
Default Buffer Size for Long/LOB Columns (in Kb)
Attribute
DefaultLongDataBuffLen (DLDBL)
Purpose
The maximum length of data (in KB) the driver can fetch from long columns in a single round trip and the maximum length of data that the driver can send using the SQL_DATA_AT_EXEC parameter.
Valid Values
An integer in multiples of 1024
The value must be in multiples of 1024 (for example, 1024, 2048). You need to increase the default value if the total size of any Long data exceeds 1 MB. This value is multiplied by 1024 to determine the total maximum length of fetched data. For example, if you enter a value of 2048, the maximum length of data would be 1024 x 2048, or 2097152 (2 MB).
Notes
*This connection option can affect performance.
Default
1024
GUI tab
Advanced tab
See Also
See Performance Considerations for details.