NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

DatabaseMetaData.getProcedures(...)
DatabaseMetaData.getProcedureColumns(...)
Stored procedures are
not available in
SQL/MX.
DatabaseMetaData.GetColumnPrivileges(...)
DatabaseMetaData.getTablePrivileges(...)
GRANT/REVOKE is
not supported in
SQL/MX.
DatabaseMetaData.getImportedKeys(...)
DatabaseMetaData.getExportedKeys(...)
DatabaseMetaData.getCrossReference(...)
Foreign keys are not
supported in SQL/MX
The following optional interfaces in the javax.sql package are not implemented in the JDBC Driver for SQL/MX:
Method Comments
javax.sql.ConnectionEventListener
javax.sql.ConnectionPooledDataSource
javax.sql.PooledConnection
Connection pooling is not applicable to the JDBC Driver
for SQL/MX. It is an in-process drive,r and no overhead is
associated with establishing a connection.
javax.sql.XAConnection
javax.sql.XADataSource
Distributed Transactions, as described in the JDBC 2.1
API specification, are not yet implemented.
javax.sql.RowSet
javax.sql.RowSetInternal
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/).
Deviations
The following table lists methods that differ in execution from the JDBC specification. When an argument in a method
is ignored, the JDBC Driver for SQL/MX does not throw 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.
Method Comments
java.sql.DriverManager.getConnection(...)
javax.sql.DataSource.getConnection(...)
User name and password
arguments are ignored. All
connections have the same
security privileges as the user
who invoked the JVM. The
properties argument is also
ignored.
java.sql.DriverManager.setLoginTImeout(...)
javax.sql.DataSource.setLoginTimeout(...)
No overhead is associated
with establishing a
connection, so login time-out
is ignored.
java.sql.DriverManager.setLogWriter
javax.sql.DataSource.setLogWriter
This method has no effect
unless the JDBC trace facility
is enabled.