JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Chapter 5. Working with BLOB and CLOB Data
Prev Next
Chapter 5. Working with BLOB and CLOB Data
Architecture for LOB Support
Setting Properties for the LOB Table
Specifying the LOB Table
Reserving Data Locators
Storing CLOB Data
Inserting CLOB Columns by Using the Clob Interface
Writing ASCII or MBCS Data to a CLOB Column
Inserting CLOB Data by Using the PreparedStatement Interface
Inserting a Clob Object by Using the setClob Method
Inserting a CLOB column with Unicode data using a Reader
Writing Unicode data to a CLOB column
Reading CLOB Data
Reading ASCII Data from a CLOB Column
Reading Unicode data from a CLOB Column
Updating CLOB Data
Updating Clob Objects with the updateClob Method
Replacing Clob Objects
Deleting CLOB Data
Storing BLOB Data
Inserting a BLOB Column by Using the Blob Interface
Writing Binary Data to a BLOB Column
Inserting a BLOB Column by Using the PreparedStatement Interface
Inserting a Blob Object by Using the setBlob Method
Reading Binary Data from a BLOB Column
Updating BLOB Data
Updating Blob Objects by Using the updateBlob Method
Replacing Blob Objects
Deleting BLOB Data
NULL and Empty BLOB or Empty CLOB Value
Transactions Involving Blob and Clob Access
Access Considerations for Clob and Blob Objects
This chapter describes working with BLOB and CLOB data in JDBC applications. You can use the standard interface described in the JDBC 3.0
API specification to access
BLOB and CLOB data in NonStop SQL/MX tables with support provided by the Type 4 driver.
BLOB and CLOB are not native data types in an SQL/MX database. But, database administrators can create SQL/MX tables that have BLOB and
CLOB columns by using the Type 4 driver or special SQL syntax in MXCI as described under Creating Base Tables that Have LOB Columns.
For management purposes,
CLOB and BLOB data is referred to as large object (LOB) data, which can represent either data type.
Note:
CLOB data types are not supported when using stored procedures in Java (SPJs).
For information about creating and managing tables for BLOB and CLOB data, see Managing the SQL/MX Tables for BLOB and CLOB Data.