JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

JDBC/MX Compliance

The JDBC/MX Driver for NonStop SQL/MX conforms where applicable to the Oracle JDBC 3.0 API

specification. However, the JDBC/MX driver differs from the JDBC standard in some ways because of

limitations of NonStop SQL/MX and the JDBC/MX driver. This subsection describes the JDBC methods that

are not supported, the methods and features that deviate from the specification, and features that are HP

extensions to the JDBC standard. JDBC features that conform to the specification are not described in this

subsection.

The topics are:

Unsupported Features

Limitation of JDBC/MX Type 2 Driver

Deviations

HP Extensions

SQL Conformance

JDBC/MX Type 2 Driver Features

Unsupported Features

The following interfaces in the java.sql package are not implemented in the JDBC/MX driver because the

data types involved are not supported by NonStop SQL/MX:

java.sql.Array

java.sql.Ref

java.sql.Savepoint

java.sql.SQLData

java.sql.SQLInput

java.sql.SQLOutput

java.sql.Struct

Note: Support for java.sql.Blob and java.sql.Clob packages require the use of SQL/MX user

tables as described in

Working with BLOB and CLOB Data. These packages are not

supported for access of SQL/MP user tables.

The following methods in the java.sql package throw an SQLException with the message "Unsupported

feature -

method-name

Method Comments

CallableStatement.getArray(int parameterIndex)

CallableStatement.getArray(String parameterName)

CallableStatement.getBlob(int parameterIndex)

CallableStatement.getBlob(String parameterName)

CallableStatement.getClob(int parameterIndex)

CallableStatement.getClob(String parameterName)

CallableStatement.getObject(int parameterIndex, Map map)

CallableStatement.getObject(String parameterName, Map map)

The particular

CallableStatement

method is not supported.