JDBC Driver for SQL/MP 3.0

With scrollable result sets, the JDBC Driver for SQL/MP might sometimes need to choose an alternative concurrency
type for a result set when the result set is created. Generally, queries that meet these criteria produce an updatable
result set:
The query references only a single table in the database.
The query does not contain any join operations.
The query selects the primary key of the table it references.
The query selects all the nonnullable columns in the underlying table.
The query selects all columns that do not have a default value.
For the type forward-only result set, although concurrency type updatable is specified, JDBC Driver for SQL/MP
switches the concurrency to type read-only.
Metadata Support
This table lists the java.SQL.DatabaseMetaData methods for data that the SQL/MP database does not contain;
therefore, NULL values are returned.
Method Comments
java.sql.DatabaseMetaData.getColumns(String
catalog, String schemaPattern, String
tableNamePattern, String
columnNamePattern)
These columns are added, but the values are set to
NULL because SQL/MP does not support the
column type for types:
SCOPE_CATLOG,
SCOPE_SCHEMA,
SCOPE_TABLE, and
SOURCE_DATA_TYPE.
java.sql.DatabaseMetaData.getSchemas()
Not applicable.
java.sql.DatabaseMetaData.getTables(String
catalog, String schemaPattern, String[]
types)
These columns are added to the column data, but
the values are set to NULL because SQL/MP does
not support the column type for types:
TYPE_CAT,
TYPE_SCHEMA,
TYPE_NAME,
SELF_REFERENCING_COL_NAME,
and REF_GENERATION.
java.sql.DatabaseMetaData.UDTs(String
catalog, String schemaPattern, String
tableNamePattern, int[] types)
Not applicable.
Batch Update Support
The batch update facility enables a Statement object to submit a set of update commands together as a single unit, or
batch, to the underlying database management system. The JDBC 2.0 documentation states that batch updates result in
a performance improvement. Because SQL/MP does not support batch updates, it is unlikely that a performance
improvement can occur if your application uses the batch update feature. Nevertheless, the batch update capability is
available.
BLOBs and CLOBs