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

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