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

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
-1 (disables connection pooling). The value determines connection pool use as follows:
• Any negative value is considered as -1.
• 0 indicates no maximum pool size.
• A value of -1 disables connection pooling.
initialPoolSize property
The initialPoolSize property sets the initial connection pool size when connection pooling
is used with the JDBC/MX driver. When an application requests for the first connection, the driver
enables you to assign a value for the initialPoolSize property, for each connection pool.
The driver attempts to create and pool the number of connections assigned. For example, if
initialPoolSize is set to 5 for a data source, the driver attempts to create and pool five
connections the first time the application calls the getConnection() method of the data source.
• Data type — int
• Units — number of physical connections
• Default — -1 (If an initial connection pool is not created)
• Range — -1 to maxPoolSize
• Any negative value is treated as -1.
You can assign values less than minPoolSize, but not greater than maxPoolSize. If the value
specified is greater than maxPoolSize, the maxPoolSize property value is used.
maxIdletime property
The maxIdleTime property denotes the number of seconds a physical connection remains unused
in the pool before the connection is closed. 0 (zero) indicates no limit.
28 Accessing SQL Databases with SQL/MX