JDBC Type 4 Driver 1.1 Programmer's Reference

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
Reading CLOB Data
Reading ASCII 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
6. Managing the SQL/MX Tables for BLOB and CLOB Data
Before You Begin Managing LOB Data
Creating Base Tables that Have LOB Columns
Data Types for LOB Columns