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

The schema is used for both DDL and DML statements. The catalog represents the subvolume where the SQL object is
registered, while the schema represents the subvolume where the SQL object is located. The catalog and schema are of
the format
system_volume_subvol
with "\" and "$" removed.
Java applications can specify the default catalog and schema at run time using the system properties catalog and
schema, respectively, using -D option in the command line, as follows.
-Dcatalog=default-catalog
-Dschema=default-schema
If the default catalog and schema are not specified, the JDBC Driver for SQL/MX allows SQL/MX to follow its own
rules for defaults.
JDBC/MX Compliance
In general, the JDBC Driver for SQL/MX conforms to the Sun Microsystems JDBC 2.1 API specification. However,
the JDBC Driver for SQL/MX differs from the JDBC standard in some ways because of limitations of SQL/MX and
the JDBC/MX driver. This subsection describes the JDBC methods that are not supported, the methods and features
that deviate from the specification, and features that are Compaq extensions to the JDBC standard. JDBC features that
conform to the specification are not described in this subsection.
Unsupported Features
The following interfaces in the java.sql package are not implemented in the JDBC Driver for SQL/MX because the
data types involved are not supported by SQL/MX:
java.sql.Array●
java.sql.Blob●
java.sql.CallableStatement●
java.sql.Clob●
java.sql.Ref●
java.sql.SQLData●
java.sql.SQLInput●
java.sql.SQLOutput●
java.sql.Struct●
The following methods in the java.sql package throw an SQLException with the message "Unsupported feature
- method-name":
Method Comments
Connection.prepareCall(...)
CallableStatement is
not supported in
SQL/MX
Connection.getTypeMap(...)
Connection.setTypeMap(...)
Structured data type is
not supported in
SQL/MX.