JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

Table 3 JDBC/MX Driver Properties Used with the DriverManager Class
DescriptionValueTypeProperty Name
Communicates with JDBC driver to continue the
remaining jobs in the batch even after any
on or offStringcontBatchOnError
BatchUpdateExceptions. See “contBatchOnError
property” (page 38).
If the default catalog and schema are not specified,
the JDBC/MX driver allows SQL/MX to follow its own
rules for defaults.
See “Default Catalog
and Schema”
(page 25).
Stringcatalog
See catalog above.See “Default Catalog
and Schema”
(page 25).
Stringschema
The location (in $volume.subvolume format) in
which SQL/MP tables are created. (The default
See “mploc Property”
(page 26).
Stringmploc
location is the default subvolume of the logged-on
user.)
Enables logging of SQL statement IDs and the
corresponding JDBC SQL statements. See “enableLog
Property” (page 77).
on or offbooleanenableLog
Specifies the file to which the trace facility logs SQL
statement IDs and the corresponding JDBC SQL
statements. See “idMapFile Property” (page 77).
A valid OSS filenameStringidMapFile
Specifies the Java encoding used when accessing and
writing to ISO88591 columns.
See “ISO88591
Property” (page 26).
StringISO88591
The total number of PreparedStatement objects
that the connection pool should cache. See
“maxStatements Property” (page 26).
See “maxStatements
Property” (page 26).
intmaxStatements
Limits the number of physical connections that can be
in the free connection pool. See min PoolSize Property.
See “minPoolSize
Property” (page 26).
intminPoolSize
Sets maximum number of physical connections that
the pool should contain. This number includes both
See “maxPoolSize
Property” (page 27).
intmaxPoolSize
free connections and connections in use. See
“maxPoolSize Property” (page 27).
Sets the initial connection pool size when connection
pooling is used with the JDBC/MX driver. See
“initialPoolSize property” (page 27).
See “initialPoolSize
property” (page 27).
intinitialPoolSize
Denotes the number of seconds a physical connection
remains unused in the pool before the connection is
closed. See “maxIdletime property” (page 27).
See “maxIdletime
property” (page 27).
intmaxIdleTime
Sets the language used in error messages. See
“language Property” (page 28).
See “language
Property” (page 28)
stringlanguage
Specifies the LOB table for using BLOB columns.See “LOB Table Name
Properties” (page 25).
StringblobTableName
Specifies the LOB table for using CLOB columns.See “LOB Table Name
Properties” (page 25).
StringclobTableName
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 28).
See “transactionMode
Property” (page 28).
StringtransactionMode
Connecting to SQL/MX 21