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

java.sql.SQLOutput
java.sql.Struct
The following interfaces in the javax.sql package are not implemented in the Type 4 driver:
Method Comments
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 the Oracle Web site
(
http://java.sun.com/developer/earlyAccess/jdbc/jdbc-rowset.html).
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).
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.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).
java.sql.Connection.createStatement(...)java.sql.Connection.prepareStatement(...)
The Type 4 driver does not support the scroll-
sensitive result set type, so an
SQLWarning is
issued if an application requests that type.