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

pool size is determined by the maxPoolSize property value and minPoolSize property
value.
• By default, connection pooling is disabled. To enable connection pooling, set the
maxPoolSize property to an integer value greater than 0 (zero).
• Manage connection pooling by using the following Type 4 driver properties:
maxPoolSize◦
◦ minPoolSize
◦ initialPoolSize
◦ maxStatements
• When used with the DriverManager class, the Type 4 driver has a connection-pool manager
that determines which connections are pooled together by a unique value for the following
combination of properties:
url
catalog
schema
username
password
blobTableName
clobTableName
serverDataSource
Therefore, connections that have the same values for the combination of a set of properties
are pooled together.
NOTE: The connection-pooling property values used at the first connection of a given combination
are effective throughout the life of the process. An application cannot change any of these property
values after the first connection for a given combination.
Statement Pooling
“Guidelines for Statement Pooling” (page 27)
“Troubleshooting Statement Pooling” (page 27)
The statement pooling feature allows applications to reuse the PreparedStatement object in
same way that they can reuse a connection in the connection pooling environment. Statement
pooling is done completely transparent to the application.
26 Accessing SQL Databases with SQL/MX