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

• “mploc Property” (page 27)
• “maxStatements Property” (page 27)
• “minPoolSize Property” (page 27)
• “maxPoolSize Property” (page 28)
• “initialPoolSize property” (page 28)
• “maxIdletime property” (page 28)
• “language Property” (page 29)
• “transactionMode Property” (page 29)
• “queryExecuteTime Property” (page 30)
• “T2QueryExecuteLogFile Property” (page 31)
• “Setting Properties in the Command Line” (page 31)
These properties and additional properties can be specified in a command line, as described
under “Setting Properties in the Command Line” (page 31).
For information about using features provided by various JDBC/MX properties, see the topic,
“Using Additional JDBC/MX Properties” (page 39)
Default Catalog and Schema
The default catalog and schema are used to access SQL objects referenced in SQL statements if
the SQL objects are not fully qualified. The three-part fully qualified name for SQL/MX objects is
of the form:
[[catalog.]schema.]object-name
The catalog and schema names can be any arbitrary strings that conform to SQL identifiers. These
names conform to ANSI SQL:99 catalog and schema names.
For example, using the default catalog and schema properties for a table referenced as
CAT.SCH.TABLE, the options are:
-Djdbcmx.catalog=CAT -Djdbcmx.schema=SCH
For more information, see the HP NonStop SQL/MX Release 3.2.1 Reference Manual.
LOB Table Name Properties
LOB tables store data for LOB columns. The properties you use to specify the LOB table for using
BLOB columns or CLOB columns are:
For the BLOB columns
blobTableName
For the CLOB columns
clobTableName
The property value is of the form:
catalog_name.schema_name.lob_table_name
You can specify the name of the LOB table using properties in the following ways:
• By using the –Djdbcmx.property_name=property_value option in the java command
line. For example:
26 Accessing SQL Databases with SQL/MX