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

columnIndex)
javax.sql.JdbcRowSet.getURL(String
columnName)
javax.sql.JdbcRowSet.rollback(Savepoint
savepoint)
javax.sql.JdbcRowSet.setArray(int
parameterIndex, Array x)
javax.sql.JdbcRowSet.setRef(int
parameterIndex, Ref x)
javax.sql.JdbcRowSet.updateArray(int
columnIndex)
javax.sql.JdbcRowSet.updateArray(String
columnName)
javax.sql.JdbcRowSet.updateRef(int
columnIndex)
javax.sql.JdbcRowSet.updateRef(int
columnIndex)
For additional information about deviations for some methods, see Deviations.
Limitation of JDBC/MX Type 2 Driver
An R 3.1 version of JDBC/MX Type 2 driver cannot work with an R 2.x version of SQL/MX. If you try to
connect an R 3.1 version of JDBC/MX Type 2 driver to an
R 2.x version of SQL/MX, 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).
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