JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

The following interfaces in the java.sql package are not implemented in the Type 4 driver:
CommentsInterrface
The underlying data types are not supported by SQL/MX.
java.sql.Array
java.sql.Ref
java.sql.Savepoint
java.sql.SQLData
java.sql.SQLInput
java.sql.SQLOutput
java.sql.Struct
The following interfaces in the javax.sql package are not implemented in the Type 4 driver:
CommentsMethod
RowSet is not implemented in the JDBC Driver for
SQL/MX. You can, however, download reference
javax.sql.RowSet
javax.sql.RowSetInternal
javax.sql.RowSetListener
implementation of RowSet from the Oracle Web site
(http://java.sun.com/developer/earlyAccess/jdbc/jdbc-rowset.html).
javax.sql.RowSetMetaData
javax.sql.RowSetReader
javax.sql.RowSetWriter
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 Type 4 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
java.sql.DatabaseMetaData.getColumns(String catalog, String
schemaPattern,String tableNamePattern, String columnNamePattern)
SQL/MXdoes not support the column type
for types as follows:
SCOPE_CATALOG,
SCOPE_SCHEMA,
SCOPE_TABLE, and
SOURCE_DATA_TYPE.
The column is added to the column data,
but its value is set to NULL because
java.sql.DatabaseMetaData.getTables(String catalog, String
schemaPattern, String[] types)
SQL/MXdoes not support the column type
for types as follows:
TYPE_CAT,
TYPE_SCHEMA,
TYPE_NAME,
SELF_REFERENCING_COL_NAME,
and REF_GENERATION.
Deviations 75