JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Connection Pooling Using the Basic DataSource API...............................................................36
Connection Pooling with the DriverManager Class..................................................................37
Statement Pooling...................................................................................................................37
Guidelines for Statement Pooling..........................................................................................38
Controlling the Performance of ResultSet Processing................................................................38
Troubleshooting Statement Pooling.......................................................................................38
Using Additional JDBC/MX Properties.......................................................................................39
BatchUpdate Exception handling Improvements.....................................................................39
Statement Level Atomicity....................................................................................................40
Managing Nonblocking JDBC/MX......................................................................................40
Setting Batch Processing for Prepared Statements...................................................................41
Setting the reserveDataLocators Property...............................................................................42
Supported Character Set Encodings..........................................................................................42
4 Working with BLOB and CLOB Data...........................................................44
Architecture for LOB Support....................................................................................................44
Setting Properties for the LOB Table...........................................................................................45
Specifying the LOB Table....................................................................................................45
Reserving Data Locators......................................................................................................45
Storing CLOB Data.................................................................................................................46
Inserting CLOB Columns by Using the Clob Interface..............................................................46
Writing ASCII or Unicode Data to a CLOB Column................................................................46
Inserting CLOB Data by Using the PreparedStatement Interface................................................47
Inserting a Clob Object by Using the setClob Method.............................................................47
Reading CLOB Data...............................................................................................................47
Reading ASCII Data from a CLOB Column............................................................................48
Reading Unicode Data from a CLOB Column........................................................................48
Updating CLOB Data..............................................................................................................48
Updating Clob Objects with the updateClob Method.............................................................48
Replacing Clob Objects......................................................................................................49
Deleting CLOB Data................................................................................................................49
Storing BLOB Data..................................................................................................................49
Inserting a BLOB Column by Using the Blob Interface.............................................................49
Writing Binary Data to a BLOB Column................................................................................50
Inserting a BLOB Column by Using the PreparedStatement Interface..........................................50
Inserting a Blob Object by Using the setBlob Method.............................................................50
Reading Binary Data from a BLOB Column................................................................................51
Updating BLOB Data..............................................................................................................51
Updating Blob Objects by Using the updateBlob Method........................................................51
Replacing Blob Objects......................................................................................................51
Deleting BLOB Data................................................................................................................51
NULL and Empty BLOB or CLOB Value......................................................................................52
Transactions Involving Blob and Clob Access..............................................................................52
Access Considerations for Clob and Blob Objects.......................................................................52
5 Managing the SQL/MX Tables for BLOB and CLOB Data..............................54
Creating Base Tables that Have LOB Columns............................................................................54
Data Types for LOB Columns...............................................................................................54
Using MXCI To Create Base Tables that Have LOB Columns....................................................54
Using JDBC Programs To Create Base Tables that Have LOB Columns.......................................55
Managing LOB Data by Using the JDBC/MX Lob Admin Utility....................................................55
Running the JDBC/MX Lob Admin Utility...............................................................................55
Help Listing from the JDBC/MX Lob Admin Utility...................................................................56
Using SQL/MX Triggers to Delete LOB Data...............................................................................57
Limitations of the CLOB and BLOB Data Types............................................................................57
4 Contents