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

maxIdleTime Property
The maxIdleTime property determines the number of seconds that a physical connection should
remain unused in the pool before the connection is closed. 0 (zero) indicates no limit.
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
Units: seconds
Default: 0 (No timeout)
Range: 0 through 2147483647
Any negative value is treated as 0, which indicates that no time limit applies.
For example, to set the maximum idle time to 5 minutes (300 seconds):
java Dhpt4jdbc.maxIdleTime=300
maxPoolSize Property
The maxPoolSize property sets the maximum number of physical connections that the pool can
contain. These connections include both free connections and connections in use. When the
maximum number of physical connections is reached, the Type 4 driver throws an SQLException
and sends the message, Maximum pool size is reached.
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
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 Property
The maxStatements property sets the total number of PreparedStatement objects that the
connection pool should cache. This total includes both free objects and objects in use.
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
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 can dramatically help the performance of many applications.
44 Type 4 Driver Properties