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