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

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 40).
batchBindingjdbcmx.
Specifies the LOB table for using BLOB columns. See “LOB
Table Name Properties” (page 25).
blobTableNamejdbcmx.
Sets the default catalog. See “Default Catalog and
Schema” (page 25).
catalogjdbcmx.
Specifies the LOB table for using CLOB columns. See “LOB
Table Name Properties” (page 25).
clobTableNamejdbcmx.
Enables logging of SQL statement IDs and the
corresponding JDBC SQL statements. See “enableLog
Property” (page 77).
enableLogjdbcmx.
Specifies the file to which the trace facility logs SQL
statement IDs and the corresponding JDBC SQL statements.
See “idMapFile Property” (page 77).
idMapFilejdbcmx.
Specifies the encoding to be used when accessing or
writing to data stored in IS088591 columns. See
“ISO88591 Property” (page 26).
ISO88591jdbcmx.
Sets the maximum pool size. See “maxPoolSize Property”
(page 27).
maxPoolSizejdbcmx.
Sets the initial connection pool size when connection
pooling is used with the JDBC/MX driver. See
“initialPoolSize property” (page 27).
initialPoolSizejdbcmx.
Denotes the number of seconds a physical connection
remains unused in the pool before the connection is closed.
See “maxIdletime property” (page 27).
maxIdleTimejdbcmx.
Sets the language used in error messages. See “language
Property” (page 28).
languagejdbcmx.
Sets the total number of PreparedStatement objects that the
connection pool should cache. See “maxStatements
Property” (page 26).
maxStatementsjdbcmx.
Sets the minimum pool size. See “minPoolSize Property”
(page 26).
minPoolSizejdbcmx.
Sets the location in SQL/MP tables. See “mploc Property”
(page 26).
mplocjdbcmx.
Sets the number of data locators to be reserved. See
“Setting the reserveDataLocators Property” (page 41).
reserveDataLocatorsjdbcmx.
Sets the default schema. See “Default Catalog and
Schema” (page 25).
schemajdbcmx.
See “Managing Nonblocking JDBC/MX” (page 39).sqlmx_nowaitjdbcmx.
Specifies the trace file for logging. See “Enabling Tracing
for Application Servers” (page 75).
traceFilejdbcmx.
Sets the trace flag for logging. See “Enabling Tracing for
Application Servers” (page 75).
traceFlagjdbcmx.
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 28).
transactionModejdbcmx.
JDBC/MX Properties 31