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

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