JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

Inserting CLOB Data by Using the PreparedStatement Interface................................................57
Inserting a Clob Object by Using the setClob Method.............................................................58
Inserting a CLOB column with Unicode data using a Reader....................................................58
Writing Unicode data to a CLOB column..............................................................................58
Reading CLOB Data...............................................................................................................58
Reading ASCII Data from a CLOB Column............................................................................58
Reading Unicode data from a CLOB Column.........................................................................59
Updating CLOB Data..............................................................................................................59
Updating Clob Objects with the updateClob Method.............................................................59
Replacing Clob Objects......................................................................................................60
Deleting CLOB Data................................................................................................................60
Storing BLOB Data..................................................................................................................60
Inserting a BLOB Column by Using the Blob Interface.............................................................60
Writing Binary Data to a BLOB Column................................................................................61
Inserting a BLOB Column by Using the PreparedStatement Interface..........................................61
Inserting a Blob Object by Using the setBlob Method.............................................................61
Reading Binary Data from a BLOB Column................................................................................61
Updating BLOB Data..............................................................................................................62
Updating Blob Objects by Using the updateBlob Method........................................................62
Replacing Blob Objects......................................................................................................62
Deleting BLOB Data................................................................................................................62
NULL and Empty BLOB or Empty CLOB Value.............................................................................63
Transactions Involving Blob and Clob Access..............................................................................63
Access Considerations for Clob and Blob Objects.......................................................................63
6 Managing the SQL/MX Tables for BLOB and CLOB Data..............................64
Before You Begin Managing LOB Data......................................................................................64
Creating Base Tables that Have LOB Columns............................................................................64
Data Types for LOB Columns...............................................................................................64
Using MXCI To Create Base Tables that Have LOB Columns....................................................65
Using JDBC Programs To Create Base Tables that Have LOB Columns.......................................65
Managing LOB Data by Using the Lob Admin Utility...................................................................65
Running the Lob Admin Utility..............................................................................................66
Help Listing from the Type 4 Lob Admin Utility.......................................................................67
Creating LOB Tables..........................................................................................................67
Using SQL/MX Triggers to Delete LOB Data...............................................................................67
Backing Up and Restoring LOB Columns....................................................................................68
Limitations of LOB Data (CLOB and BLOB Data Types).................................................................68
7 Module File Caching (MFC).......................................................................70
MFC Overview.......................................................................................................................70
MFC Design..........................................................................................................................70
Configuring MFC....................................................................................................................70
Enabling MFC........................................................................................................................70
MFC Usage Scenarios.............................................................................................................71
MFC Tuning Recommendations.................................................................................................71
MFC Limitations......................................................................................................................72
8 Type 4 Driver Compliance.........................................................................73
Compliance Overview.............................................................................................................73
Unsupported Features..............................................................................................................73
Deviations.............................................................................................................................75
HP Extensions........................................................................................................................76
Internationalization of Messages..........................................................................................76
Conformance of DatabaseMetaData Methods' Handling of Null Parameters..................................77
Type 4 Driver Conformance to SQL Data Types...........................................................................77
Contents 5