JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

CommentsMethod
SCOPE_SCHEMA,
nl
SCOPE_TABLE, and
nl
SOURCE_DATA_TYPE.
TABLE_CATALOG is added to the column data and returns
the catalog name.
java.sql.DatabaseMetaData.getSchemas()
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:
nl
java.sql.DatabaseMetaData.getTables(Stringcatalog,
String schemaPattern, String[] types)
TYPE_CAT,
nl
TYPE_SCHEMA,
nl
TYPE_NAME,
nl
SELF_REFERENCING_COL_NAME, and
nl
REF_GENERATION.
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.getUDTs(String catalog,String
schemaPattern, String tableNamePattern,int[] types)
Mimics the
DatabaseMetaData.getBestRowIdentifier()
java.sql.DatabaseMetaData.getVersionColumns()
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).
User name and password arguments are ignored. All
connections have the same security privileges as the user
who invoked the Java VM.
java.sql.DriverManager.getConnection(String
url,String usr, String password)
java.sql.DriverManager.getConnection(String
url,Properties info)
javax.sql.DataSource.getConnection(Stringusername,
String password)
Login time-out is ignored.
java.sql.DriverManager.setLoginTImeout(...)
javax.sql.DataSource.setLoginTimeout(...)
This method has no effect unless the JDBC trace facility is
enabled; for information on the JDBC trace facility, seethe
NonStop Server for Java Programmer's Reference.
javax.sql.DataSource.setLogWriter
The JDBC/MX driver does not support the scroll-sensitive
result set type, so an SQLWarning is issued if an
java.sql.Connection.createStatement(...)
java.sql.Connection.prepareStatement(...)
application requests that type. The result set is changed to
a scroll-insensitive type.
The read-only attribute is ignored.
java.sql.Connection.setReadOnly(...)
For CLOB and BLOB columns, these methods return 0 to
denote an unlimited value. According to the standard API,
java.sql.ResultSetMetaData.getPrecision(intcolumn)
java.sql.ResultSetMetaData.getColumnDisplaySize(intcolumn)
the getPrecision () method and
getColumnDisplatSize () method return an integer
value, but LOB data larger than the maximum integer value
can be stored in the database.
The fetch direction attribute is ignored.
java.sql.ResultSet.setFetchDirection(...)
Because SQL/MX parses the escape syntax, disabling
escape processing has no effect.
java.sql.Statement.setEscapeProcessing(...)
The fetch direction attribute is ignored.
java.sql.Statement.setFetchDirection(...)
The query time-out value is ignored. The JDBC/MX driver
does not abort execution when the query time-out period
has expired.
java.sql.Statement.setQueryTimeout(...)
66 JDBC/MX Compliance