NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

Column aliasing is not supported because SQL/MP does not support column aliasing.●
The ODBC minimum SQL grammar is not supported. Therefore, the JDBC Driver for SQL/MP does not support the
following:
Numeric functions, string functions, system functions, or the convert function.❍
Escape syntax for time or date literals, LIKE escape characters, or escape characters for outer joins. Because
SQL/MP does not support stored procedures, escape syntax is not supported for stored procedures.
❍
●
The ANSI92 entry-level SQL grammar is not supported because SQL/MP does not conform to Entry Level SQL as
described in the ANSI and ISO/IEC standards for that topic.
●
The JDBC specification identifies several areas that are optional and need not be supported if the database management system
does not provide support. The JDBC Driver for SQL/MP does not support the following optional interfaces:
SQL3 data types, which include Array, Ref, and Struct. SQL/MP does not support those data types.●
Custom type-maps used to map between SQL user-defined data types and Java classes. These type-maps include
SQLData, SQLInput, and SQLOutput, which are used in conjunction with custom type-maps. SQL/MP does not
support user-defined data types.
●
Any methods that use java.util.Map, such as Connection.setTypeMap(). These methods are not supported
because their only function is to provide custom type-maps, which are not supported.
●
ConnectionEventListener, ConnectionPoolDataSource, and PooledConnection classes. SQL/MP
does not support connection pooling.
●
XAConnection and SADataSource classes, which are used to support distributed transactions None of the classes
or interfaces in javax.transaction.xa are supported.
●
All other areas of the JDBC Driver for SQL/MP are compliant with the JDBC specifications, including such optional features
as BLOBs, CLOBs, and DataSource support.
JDBC Driver for SQL/MP Support for JDBC 2.0
This subsection provides specific information about how the JDBC Driver for SQL/MP supports the JDBC 2.0 API in the areas
of:
Result Sets●
Batch Updates●
BLOBs and CLOBs●
JDBC 2.0 Standard Extensions●
Result Set Support
As of JDBC 2.0, serveral changes were made to result sets. These changes are in the areas of scrolling and concurrency.
Scrolling
JDBC 2.0 identifies three types of result sets: forward-only, scroll-insensitive, and scroll-sensitive. Both scroll-related result
set types support scrolling, but they differ in their ability to make changes in the data base visible while the result set is open. A
scroll-insensitive result set provides a static view of the underlying data it contains (the data is fixed when the result set is
created). A scroll-sensitive result set is sensitive to underlying changes that are made in the data while the result set is open.
The JDBC Driver for SQL/MP supports scroll-insensitive result sets. JDBC/MP supports scroll-insensitive result sets by
storing the entire result set in memory. For this reason, if you select a large scroll-insensitive result set, performance can be
affected. In some instances, the JDBC Driver for SQL/MP may choose an alternative result set type when the result set is
created.