JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

The following optional interfaces in the javax.sql package are not implemented in the JDBC/MX

driver:

CommentsMethod

Distributed Transactions, as described in the JDBC 3.0 API

specification, are not yet implemented.

javax.sql.XAConnection

javax.sql.XADataSource

RowSet is not implemented in the JDBC/MX driver. You

can, however, download reference implementation of

javax.sql.RowSet

javax.sql.RowSetInternal

javax.sql.RowSetListener

RowSet from Oracle ( http://java.sun.com/developer/

earlyAccess/jdbc/jdbc-rowset.html).

javax.sql.RowSetMetaData

javax.sql.RowSetReader

javax.sql.RowSetWriter

The JdbcRowSet API methods are supported except for

these that throw an Unsupported feature

-method-name SQLMXException.

javax.sql.JdbcRowSet.getArray(intcolumnIndex)

javax.sql.JdbcRowSet.getArray(StringcolumnName)

javax.sql.JdbcRowSet.getObject(intcolumnIndex,

Map map)

javax.sql.JdbcRowSet.getObject(StringcolumnName,

Map map)

javax.sql.JdbcRowSet.getRef(intcolumnIndex)

javax.sql.JdbcRowSet.getRef(StringcolumnName)

javax.sql.JdbcRowSet.getURL(intcolumnIndex)

javax.sql.JdbcRowSet.getURL(StringcolumnName)

javax.sql.JdbcRowSet.rollback(Savepointsavepoint)

javax.sql.JdbcRowSet.setArray(intparameterIndex,

Array x)

javax.sql.JdbcRowSet.setRef(intparameterIndex,

Ref x)

javax.sql.JdbcRowSet.updateArray(intcolumnIndex)

javax.sql.JdbcRowSet.updateArray(StringcolumnName)

javax.sql.JdbcRowSet.updateRef(intcolumnIndex)

For additional information about deviations for some methods, see “Deviations” (page 65).

Limitation of JDBC/MX Type 2 Driver

JDBC/MX type 2 driver for SQL/MX Release 3.2 cannot inter-operate with SQL/MX Release 2.x.

If you try to connect a JDBC/MX type 2 driver for SQL/MX Release 3.2 to SQL/MX Release 2.x,

the behavior is unpredictable.

Deviations

The following table lists methods that differ in execution from the JDBC specification. When an

argument in a method is ignored, the JDBC/MX driver does not throw an SQLException, thus

allowing the application to continue processing. The application might not obtain the expected

results, however. Other methods listed do not necessarily throw an SQLException, unless otherwise

stated, although they differ from the specification.

NOTE: java.sql.DatabaseMetaData.getVersionColumns() method mimics the

java.sql.DatabaseMetaData.getBestRowIdentifier() method because SQL/MX does

not support SQL_ROWVER (a columns function that returns the column or columns in the specified

table, if any, that are automatically updated by the data source when any value in the row is

updated by any transaction).

CommentsMethod

The column is added to the column data, but its value is

set to NULL because SQL/MX does not support the column

type for types as follows:

java.sql.DatabaseMetaData.getColumns(Stringcatalog, String

schemaPattern, StringtableNamePattern, String

columnNamePattern)

SCOPE_CATALOG,

Limitation of JDBC/MX Type 2 Driver 65