A large object (LOB) is a data item that is too large to be directly stored in a database table. The workaround is to store a locator in the database table. The locator points to the actual location of the data item.
OceanBase Connector/J uses streams to support the following LOB data types:
Binary large object (
BLOB)This data type is used for unstructured binary data.
Character large object (
CLOB)This data type is used for character data.
National character large object (
NCLOB)This data type is used for national character data.
Data of the BLOB, CLOB, and NCLOB types are permanently stored in database tablespaces. All operations performed on such data are controlled by transactions.
Procedural Language (PL) supports the LOB data types. The Java Database Connectivity (JDBC) API allows you to pass IN parameters to PL stored procedures or functions and retrieve OUT parameters or returned values.
The behaviors of LOB data are different from those of other types of streaming data described in other topics of this chapter. LOB data is not directly stored in a table. Only the locator is. You can use the locator to manipulate the actual data, including reading and writing data as a stream. Even during the streaming transmission of LOB data, only necessary data is moved on the network. However, during the streaming transmission of LONG or LONG RAW data, all data are moved on the network.
When you use a query to get one or more BLOB, CLOB, or NCLOB columns, OceanBase Connector/J transmits the data to the client so that the data stream can be accessed.