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

Unsupported NonStop SQL Features.........................................................................................78
Unsupported SQL/MX Features............................................................................................78
Unsupported SQL/MP Features............................................................................................79
Other Unsupported Features....................................................................................................79
Restrictions.............................................................................................................................79
java.sql.connection.setAutoCommit(boolean autoCommit())..........................................................79
9 Tracing and Logging Facilities....................................................................80
Standard JDBC Tracing and Logging Facility..............................................................................80
The Type 4 Driver Logging Facility.............................................................................................80
Accessing the Type 4 Driver Logging Facility..........................................................................81
Controlling Type 4 Driver Logging Output..............................................................................81
Message Format................................................................................................................81
Examples of Logging Output...............................................................................................82
Controlling the QueryExecuteTime Logging Facility.................................................................83
QueryExecuteTime logging Message Format..........................................................................83
Examples of QueryExecuteTime Logging Output.....................................................................83
10 Migration and Compatibility....................................................................84
JDBC Drivers..........................................................................................................................84
Third-Party Databases..............................................................................................................84
Operating Systems..................................................................................................................84
Compatibility.........................................................................................................................84
11 Messages...............................................................................................85
About the Message Format......................................................................................................85
Type 4 Driver Error Messages...................................................................................................85
12 Providing a secure JDBC connection using NonStop SSL.............................107
Encrypting the JDBC connection.............................................................................................107
Secure JDBC connection architecture.......................................................................................107
Installing a NonStop SSL Server process for ODBC/MX.............................................................107
Installing and configuring the Remote Proxy Client on the Windows workstation............................108
Modifying the connection string and properties file of the JDBC Type 4 driver...............................109
A Sample Programs Accessing CLOB and BLOB Data....................................110
Sample Program Accessing CLOB Data...................................................................................110
Sample Program Accessing BLOB Data...................................................................................112
Glossary..................................................................................................116
6 Contents