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

Table 5 JDBC/MX Driver Properties Allowed in the Command Line (continued)
DescriptionProperty NameJDBC/MX Prefix
Specifies that statements are batched together in the
executeBatch() operation. See “Setting Batch
Processing for Prepared Statements” (page 41).
batchBindingjdbcmx.
Specifies the LOB table for using BLOB columns. See “LOB
Table Name Properties” (page 26).
blobTableNamejdbcmx.
Sets the default catalog. See “Default Catalog and
Schema” (page 26).
catalogjdbcmx.
Specifies the LOB table for using CLOB columns. See “LOB
Table Name Properties” (page 26).
clobTableNamejdbcmx.
Enables logging of SQL statement IDs and the
corresponding JDBC SQL statements. See “enableLog
Property” (page 78).
enableLogjdbcmx.
Specifies the file to which the trace facility logs SQL
statement IDs and the corresponding JDBC SQL statements.
See “idMapFile Property” (page 78).
idMapFilejdbcmx.
Specifies the encoding to be used when accessing or
writing to data stored in IS088591 columns. See
“ISO88591 Property” (page 27).
ISO88591jdbcmx.
Sets the maximum pool size. See “maxPoolSize Property”
(page 28).
maxPoolSizejdbcmx.
Sets the initial connection pool size when connection
pooling is used with the JDBC/MX driver. See
“initialPoolSize property” (page 28).
initialPoolSizejdbcmx.
Denotes the number of seconds a physical connection
remains unused in the pool before the connection is closed.
See “maxIdletime property” (page 28).
maxIdleTimejdbcmx.
Sets the language used in error messages. See “language
Property” (page 29).
languagejdbcmx.
Sets the total number of PreparedStatement objects that the
connection pool should cache. See “maxStatements
Property” (page 27).
maxStatementsjdbcmx.
Sets the minimum pool size. See “minPoolSize Property”
(page 27).
minPoolSizejdbcmx.
Sets the location in SQL/MP tables. See “mploc Property”
(page 27).
mplocjdbcmx.
Sets the number of data locators to be reserved. See
“Setting the reserveDataLocators Property” (page 42).
reserveDataLocatorsjdbcmx.
Sets the default schema. See “Default Catalog and
Schema” (page 26).
schemajdbcmx.
See “Managing Nonblocking JDBC/MX” (page 40).sqlmx_nowaitjdbcmx.
Specifies the trace file for logging. See “Enabling Tracing
for Application Servers” (page 76).
traceFilejdbcmx.
Sets the trace flag for logging. See “Enabling Tracing for
Application Servers” (page 76).
traceFlagjdbcmx.
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 29).
transactionModejdbcmx.
32 Accessing SQL Databases with SQL/MX