JDBC Type 4 Driver 1.1 Programmer's Reference

LOB Architecture: Tables for LOB Data Support
Setting Properties for the LOB Table
Specifying the LOB Table
Reserving Data Locators
Before running the JDBC application that uses BLOB and CLOB data through the JDBC API,
the database administrator must create the LOB tables. For information on creating LOB tables,
see Managing LOB Data with the Lob Admin Utility.
The JDBC applications that access BLOB or CLOB data must specify the associated LOB table
names and, optionally, configure the reserveDataLocators property.
Specifying the LOB Table
At run time, a user JDBC application notifies the Type 4 driver of the name or names of the
LOB tables associated with the CLOB or BLOB columns of the base tables being accessed by
the application. One LOB table or separate tables can be used for BLOB and CLOB data.
The JDBC application specifies a LOB table name either through a system parameter or through
a Java Property object by using one of the following properties, depending on the LOB
column type:
LOB Column Type Property name
BLOB blobTableName
CLOB clobTableName
For more information about using these properties, see LOB Table Name Properties.