JDBC Type 4 Driver 1.1 Programmer's Reference

java.sql.Array
java.sql.Ref
java.sql.Savepoint
java.sql.SQLData
java.sql.SQLInput
java.sql.SQLOutput
java.sql.Struct
The underlying data types are not supported by SQL/MX.
The following interfaces in the javax.sql package are not implemented in the Type 4 driver:
Method Comments
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 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.