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

CommentsMethod
User name and password arguments are ignored. Security
privileges are the same as for the user who invoked the
Java VM.
javax.sql.JdbcRowSet.setUsername(String
username)
javax.sql.JdbcRowSet.setPassword(String
password)
javax.sql.JdbcRowSet(String url, String
username,String password)
The read-only attribute is ignored.
javax.sql.JdbcRowSet.setReadOnly(...)
Disabling escape processing has no effect because
SQL/MX parses the escape syntax.
javax.sql.JdbcRowSet.setEscapeProcessing(...)
The fetch direction attribute is ignored.
javax.sql.JdbcRowSet.setFetchDirection(...)
The query time-out value is ignored. The JDBC/MX driver
does not abort execution when the query time-out period
has expired.
javax.sql.JdbcRowSet.setQueryTimeout(...)
The following features are implemented in the JDBC/MX driver but might differ in implementation
from other drivers:
Updatable Result Set
The JDBC/MX driver supports both read-only and updatable concurrency modes. The JDBC/MX
driver expects the following criteria for a result set to be updatable:
• The table name of the first column in the result set is assumed to be the table to be updated.
This assumption allows queries from multiple tables also to be updatable.
• The query selects the primary key columns of the table to be updated.
The JDBC/MX driver throws an SQLException when any of the following conditions occur:
• The primary key columns are updated.
• Any selected column has been updated since the most recent time it was read. (However, the
JDBC/MX driver does not ensure that columns in the table that are not part of the select query
remain unchanged since the row was most recently read.)
• A query does not select nonnullable columns or columns that do not have a default value.
The result set is also affected in the following ways:
• A deleted row is removed from the result set. The method
databaseMetaData.deletesAreDetected()returns false.
• An inserted row is added to the result set at the current cursor position. The method
databaseMetaData.insertsAreDetected()returns true.
Batch Updates
The batch update facility allows a Statement object to submit a set of heterogeneous update,
insert, or delete commands together as a single unit to the database. This facility also allows multiple
sets of parameters to be associated with a PreparedStatement object.
When the autocommit mode is enabled, the JDBC/MX driver commits the updates only when all
commands in the batch succeed. If any command in the batch fails, the updates are rolled back
in both autocommit and nonautocommit mode.
With the BatchUpdate Exception handling improvements support, JDBC driver now continues
processing the remaining jobs in the batch even after BatchUpdateExceptions. If there is any Batch
exceptions encountered during the execution, the exception is queued up and the remaining batch
commands are executed. At the execution completion of all elements in the batch the queued
exceptions are thrown. The user application must handle, commit, or rollback of batch transaction
Deviations 67