skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : LobStreamingProtocol
  
LobStreamingProtocol
Purpose
Determines whether streaming or materialization (client caching) is used when the driver fetches LOB and XML data. In most cases, streaming provides better performance; however, materialization can reduce network round trips to the database server when updating LOB data using Clob and Blob objects, which can improve performance.
Valid Values
streaming | materialize
Behavior
If set to streaming, the driver determines the most efficient way to return LOB and XML data based on the following conditions:
*Whether streaming is supported by the database server
*Whether the application requests the data as a stream
For example, if streaming is supported by the database server and an application requests LOB data for a row as a stream, the driver uses streaming to transport the data. If streaming is not supported by the database server or if the application requests the data as a byte array or a String, the driver fully materializes the data on the client.
If set to materialize, the driver fully materializes the data on the client instead of using streaming.
Default
streaming
Data Type
String
See also
Performance Considerations