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

Table 4 DataSource Object Properties (continued)
DescriptionValueTypeProperty Name
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
Stringschema
Schema”
(page 26)
The registered ConnectionPoolDataSource name.
When this string is empty, connection pooling is used
StringdataSourceName
by default with the pool size determined by the
maxPoolSize property and minPoolSize property of the
basic DataSource object. For more information, see
“Connection Pooling Using the Basic DataSource API”
(page 36).
The description of the data source.Any valid identifierStringdescription
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
filename
StringidMapFile
Specifies the Java encoding used when accessing and
writing to ISO88591 columns.
See “ISO88591
Property”
(page 27).
StringISO88591
Sets maximum number of physical connections that the
pool should contain. This number includes both free
See “maxPoolSize
Property”
(page 28).
intmaxPoolSize
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
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 “minPoolSize Property”
(page 27).
See “minPoolSize
Property”
(page 27).
intminPoolSize
The location (in $volume.subvolume format) in
which SQL/MP tables are created (The default location
is the default subvolume of the logged-on user.)
See “mploc
Property”
(page 27).
Stringmploc
24 Accessing SQL Databases with SQL/MX