JDBC Type 4 Driver Programmer's Reference

DATETIME SECOND
DATETIME FRACTION
Floating-Point Support
The Type 4 driver supports only IEEE floating-point data to be passed between the application client and the Type 4 driver.
Note: Any data access to or from a column with Tandem floating-point format in SQL/MP, may result in loss of precision of the
data.
SQLJ Support
The Type 4 driver supports non-customized SQLJ applications, but does not support customized SQLJ applications.
Unsupported NonStop SQL Features
Unsupported SQL/MX Features
MXCI commands●
SQL/MX utility commands●
SQL Statements
Transaction Control statements❍
Prepared SQL statements (PREPARE and EXECUTE)❍
Resource control and optimization statements❍
object naming statements❍
alias statements❍
●
Refer to the NonStop SQL/MX documentation set for a complete list of supported features.
Unsupported SQL/MP Features
SQL/MP DDL support●
Utility commands●
Embedded-only SQL/MP statements●
Transaction Control statements●
Stored procedures.●
Refer to the NonStop SQL/MP documentation set for a complete list of supported features.
Other Unsupported Features
These features are not required for JDBC 3.0 compliance, and they are not supported by the NonStop JDBC Type 4 Driver.
Multiple result sets returned by batch statements.●
Database savepoint support. (Not provided in SQL/MX 2.0)●
Retrieval of auto generated keys.●
Transform group and type mapping.●
Relationship between connector architecture and JDBC 3.0 SPI.●
Secured socket communication or encryption for the interaction between the NonStop JDBC Type 4 Driver and MXCS.●