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

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
Any negative value is treated like -1. Any value greater than maxPoolSize is changed to the
maxPoolSize value. The value of minPoolSize is set to -1 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 Type 4 driver closes subsequent connections by physically closing them—and not adding
them to the free pool.
• 0 (zero) means that the connections are not physically closed; the connections are always
added to the free pool when the connection is closed.
For example, use the following specification to set the minPoolSize value to 1, which ensures
that one connection is always retained:
minPoolSize=1
networkTimeout
The networkTimeout property sets a time limit that the driver waits for a reply from the database
server. When an operation is attempted for a period longer than the set value, in seconds, the
driver stops waiting for a reply and returns an SQLException to the user application.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
NOTE: Be careful when using this property. A network timeout causes the socket connection
between the Type 4 driver and the MXCS server to timeout. If the server is engaged in a transaction
or an SQL operation, then the server continues to perform that transaction or operation until the
transaction or operation fails, TMF times out, or the server realizes that the Type 4 driver client has
gone away. A network timeout can result in an open transaction or operation that continues for a
significant time before failing or rolling back.
As a result of a network timeout, the connection becomes unavailable.
Data type: int
Units: seconds
Default: 0 (No network timeout is specified.)
0 through to 2147483647
password
The password property sets the Guardian password value for to MXCS. The password is encrypted
when it is passed to MXCS. Set this property on a DataSource object,
ConnectionPoolDataSource object, or DriverManager object.
Type 4 Driver Property Descriptions 45