Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

NOTE: Statement pooling can be in effect only if connection pooling is enabled.
For example, to specify statement pooling, type: maxStatements=10
minPoolSize Property
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. For information about how to set properties, see “How to Specify JDBC
Type 4 Properties” (page 38).
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 Property
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. For information about how to set properties, see “How to Specify JDBC
Type 4 Properties” (page 38).
CAUTION: Be careful when using this property. A network timeout causes the socket connection
between the Type 4 driver and the HP connectivity 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, the transaction manager 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
Type 4 Driver Property Descriptions 45