JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

Units: number of physical connections
Default: -1 (Disables connection pooling.)
Range: -1, 0 through 2147483647, but greater than minPoolSize
The value determines connection-pool use as follows:
Any negative value is treated like -1.
0 means no maximum pool size.
A value of -1 disables connection pooling.
Any positive value less than minPoolSize is changed to the minPoolSize value.
maxStatements
The maxStatements property sets the total number of PreparedStatement objects that the
connection pool must cache. This total includes both free objects and objects in use. The JDBC T4
driver side cache uses the Most Frequently Used (MFU) or the Most Recently Used (MRU) algorithms.
MFU is the default setting. For more information on selecting the algorithm that you want, see
“mfuStatementCache” (page 44).
MFU-When the number of PreparedStatements in the cache exceeds the specified
maxStatements property, the least used PreparedStatement is closed and removed from
the statement cache to allow a new statement.
MRU-When the number of PreparedStatements in the cache exceeds the specified
maxStatements property value, the recently used PreparedStatements are retained and the
earliest PreparedStatement is removed from the statement cache.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: int
Units: number of objects
Default: 0 (Disables statement pooling.)
Range: 0 through 2147483647
The value 0 disables statement pooling. Any negative value is treated like 0 (zero).
Performance tip:
HP recommends that you enable statement pooling for your JDBC applications because this pooling
helps the performance of many applications.
For example, to specify statement pooling, type: maxStatements=10
The working of the PreparedStatement Caching algorithm is as described in the following
section.
mfuStatementCache
The JDBC T4 driver supports the following statement caching algorithms:
• Most Frequently Used (MFU)
• Most Recently Used (MRU)
The mfuStatementCache property enables you to select a statement caching algorithm. MFU
is the default caching algorithm.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
44 Type 4 Driver Properties