The term large object (LOB) refers to a data item that is too large to be stored directly in a database table.
Instead, a locator is stored in the database table, which points to the location of the actual data.
This can refer to the SQL type
CLOB. LOB streaming (
CLOB) is enabled by default in the NuoDB JDBC driver.
When a query fetches a
CLOB column, the NuoDB JDBC driver transfers the data to the client.
This data can be accessed as a stream using
LOB streams are chunked, by default, in 65536 byte chunks.
This can be overwritten by the
lobChunkSize connection property.
There are two connection properties that control LOB streaming. They are:
If set to true, LOB streaming is enabled.
Overrides the default maximum chunk size for LOB streaming.
ResultSet.getClob() will read the
lobChunkSize sized chunks from server into memory buffer and wrap that buffer.
LOB uploading in chunks (
setClob()) is not currently supported.