JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

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