JDBC Driver for SQL/MX Programmer's Reference
Setting Properties for the LOB Table
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 JDBC/MX Lob Admin Utility.
The JDBC applications that access BLOB or CLOB data must specify the associated LOB table
names and, optionally, configure the reserveDataLocator property. These tasks are
described in the topics:
Specifying the LOB Table●
Reserving Data Locators●
Specifying the LOB Table
At run time, a user JDBC application notifies the JDBC/MX 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