MX 2.x)

JDBC/MX Compliance

The JDBC/MX Driver for NonStop SQL/MX conforms where applicable to the Sun Microsystems 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

Deviations

HP Extensions

SQL Conformance

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)

CallableStatement.getRef(int parameterIndex)

CallableStatement.getRef(String parameterName)

The particular

CallableStatement method

is not supported.