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

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
Default: YES
Available values: YES and NO. For example, mfuStatementCache = NO
For information on enabling caching, see “maxStatements” (page 44).
minPoolSize
The minPoolSize property limits the number of physical connections that can be in the free
connection pool.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: int
Default: -1 (The minPoolSize value is ignored.)
Range: -1, 0 through n, but less than maxPoolSize
Type 4 Driver Property Descriptions 45