JDBC Type 4 Driver Programmer's Reference

loginTimeOut
When a connection is attempted for a period longer than the set value, in seconds, for loginTimeOut, the connection disconnects.
Default = 60 seconds●
If set to 0 (zero), there is no login timeout specified.●
Stored Procedures
Java applications can use the JDBC standard CallableStatement interface to run stored procedures (SPJs) by using the CALL
statement. For further information, see the SQL/MX Guide to Stored Procedures in Java.
Unsupported features
An SPJ returning java.sql.ResultSet●
executeBatch for callableStatements●
setXXX() methods with parameter names instead of parameter numbers.●
Connection Pooling
The Type 4 driver provides an implementation of connection pooling, where a cache of physical database connections are assigned to a
client connection session and reused for the database activity. Once the client session is closed, the physical connection is put back into
cache for subsequent use. This implementation contrasts to the basic DataSource object implementation, where a one-to-one
correspondence exists between client Connection object and the physical database connection.
Your applications can use connection pooling in the following ways:
Connection Pooling With the DriverManager Class●
Standard ConnectionPoolDataSource Object Properties
Note: The application server defines the meaning of these properties.
Property Name Type Description
maxStatements int
The total number of PreparedStatement
objects that the pool should cache. This total
includes both free objects and objects in use.
0 (zero) disables statement pooling.
initialPoolSize int
The number of physical connections the pool
should contain when it is created.
minPoolSize int
The number of physical connections the pool
should keep available at all times. 0 (zero)
indicates no maximum size.
maxPoolSize int
The maximum number of physical connections
that the pool should contain. 0 (zero) indicates
no maximum size.
maxIdleTime int
The number of seconds that a physical
connection should remain unused in the pool
before the connection is closed. 0 (zero)
indicates no limit.