JDBC Driver for SQL/MX Programmer's Reference

applications, because this pooling can dramatically help the performance of many applications.
minPoolSize Property
Limits the number of physical connections that can be in the free connection pool. Specify the
minPoolSize property as:
int
The integer can be 0 through 2147483647, but less than maxPoolSize. The default is 0. Any
negative value is treated like 0. Any value greater than maxPoolSize is changed to the
maxPoolSize value. This value is ignored when maxPoolSize is -1. The value determines
connection pool use as follows:
When the number of physical connections in the free pool reaches the minPoolSize value,
the JDBC/MX driver closes subsequent connections by physically closing them—not by
adding them to the free pool.
●
0 means the connections are not physically closed; the connections are always added to the
free pool when the connection is closed.
●
maxPoolSize Property
Sets the maximum number of physical connections that the pool can contain. These connections
include both free connections and connections in use. When the maximum number of physical
connections is reached, the JDBC/MX driver throws an SQLException with the message,
"Maximum pool size is reached." Specify the maxPoolSize property as:
int
The integer can be -1, 0 through 2147483647, but greater than minPoolSize. The default is 0.
Any negative value is treated like -1. Any positive value less than minPoolSize is changed to the
minPoolSize value. The value determines connection pool use as follows:
0 means no maximum pool size.●
-1 for the basic DataSource object means connection pooling is disabled. -1 is invalid for
the ConnectionPoolDatasource object.
●
transactionMode Property
The transactionMode property provides control over how and when transactions are performed.
Specify the transactionMode property as:
String
The default is mixed. The allowed values are:
external
Specifies performing all SQL operations exclusively within a JDBC internally managed
transaction independent of an existing external transaction.