JDBC Driver for SQL/MX Programmer's Reference

Note: Do not use the SHORTANSI name type with stored procedures in Java (SPJs);
SPJs do not support SHORTANSI.
SQL Context Management
NonStop SQL/MX allows you to manage SQL/MX contexts. An SQL/MX context can be
considered as an instance of the SQL/MX executor that has its own execution environment that
contains the following:
CONTROL and SET information●
A transaction●
An SQL/MX compiler process (MXCMP)●
Set of SQL/MX executive server processes (ESPs)●
User-created SQL statements●
The JDBC/MX driver maps a JDBC connection to an SQL/MX context. Therefore, in a
multithreaded application, a JDBC application has multiple SQL/MX compiler processes (MXCMP
processes) associated with the application. An SQL/MX context is created when the application
obtains a JDBC connection. An SQL/MX context is destroyed when the application explicitly or
implicitly closes the JDBC connection.
The following JDBC connection attributes are passed to the SQL/MX context by the JDBC/MX
driver by executing the corresponding SQL statements:
Connection Attributes Passed to the SQL/MX Context
Attribute SQL Statement
catalog
SET CATALOG
default-catalog-name
schema SET SCHEMA default-schema-name
mploc SET MPLOC default-location
transaction
isolation
SET TRANSACTION
isolation-level
A process (JVM process) can have multiple SQL/MX contexts within a process.