JDBC Driver for SQL/MX Programmer's Reference

ManualsBrandsHP ManualsServerHP NonStop G-Series

javax.sql.XAConnection

javax.sql.XADataSource

Distributed Transactions, as described in the JDBC 3.0

API specification, are not yet implemented.

javax.sql.RowSet

javax.sql.RowSetInternal

javax.sql.RowSetListener

javax.sql.RowSetMetaData

javax.sql.RowSetReader

javax.sql.RowSetWriter

RowSet is not implemented in the JDBC Driver for

SQL/MX. You can, however, download reference

implementation of RowSet from Sun Microsystems

(http://developer.java.sun.com/developer/earlyAccess/crs/).

For additional information about deviations for some methods, see Deviations.

Deviations

The following table lists methods that differ in execution from the JDBC specification. When an argument in a method is ignored, the JDBC

Driver for SQL/MX 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).

Method Comments

java.sql.DatabaseMetaData.getColumns(String

catalog, String schemaPattern, String

tableNamePattern, String columnNamePattern)

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:

SCOPE_CATALOG,

SCOPE_SCHEMA,

SCOPE_TABLE, and

SOURCE_DATA_TYPE.

java.sql.DatabaseMetaData.getSchemas()

TABLE_CATALOG is added to the column data and

returns the catalog name.

java.sql.DatabaseMetaData.getTables(String catalog,

String schemaPattern, String[] types)

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:

TYPE_CAT,

TYPE_SCHEMA,

TYPE_NAME,

SELF_REFERENCING_COL_NAME,

and REF_GENERATION.

java.sql.DatabaseMetaData.getUDTs(String catalog,

String schemaPattern, String tableNamePattern,

int[] types)

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

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

type.

java.sql.DatabaseMetaData.getVersionColumns()

Mimics the

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).