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

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 39).
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 26).
Stringcatalog
See catalog above.See “Default Catalog
and Schema”
(page 26).
Stringschema
The location (in $volume.subvolume format) in
which SQL/MP tables are created. (The default
See “mploc Property”
(page 27).
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 78).
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 78).
A valid OSS filenameStringidMapFile
Specifies the Java encoding used when accessing and
writing to ISO88591 columns.
See “ISO88591
Property” (page 27).
StringISO88591
The total number of PreparedStatement objects
that the connection pool should cache. See
“maxStatements Property” (page 27).
See “maxStatements
Property” (page 27).
intmaxStatements
Limits the number of physical connections that can be
in the free connection pool. See min PoolSize Property.
See “minPoolSize
Property” (page 27).
intminPoolSize
Sets maximum number of physical connections that
the pool should contain. This number includes both
See “maxPoolSize
Property” (page 28).
intmaxPoolSize
free connections and connections in use. See
“maxPoolSize Property” (page 28).
Sets the initial connection pool size when connection
pooling is used with the JDBC/MX driver. See
“initialPoolSize property” (page 28).
See “initialPoolSize
property” (page 28).
intinitialPoolSize
Denotes the number of seconds a physical connection
remains unused in the pool before the connection is
closed. See “maxIdletime property” (page 28).
See “maxIdletime
property” (page 28).
intmaxIdleTime
Sets the language used in error messages. See
“language Property” (page 29).
See “language
Property” (page 29)
stringlanguage
Specifies the LOB table for using BLOB columns.See “LOB Table Name
Properties” (page 26).
StringblobTableName
Specifies the LOB table for using CLOB columns.See “LOB Table Name
Properties” (page 26).
StringclobTableName
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 29).
See “transactionMode
Property” (page 29).
StringtransactionMode
22 Accessing SQL Databases with SQL/MX