JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

loginTimeout Property
The loginTimeout property sets the time limit that a connection can be attempted before the
connection disconnects. When a connection is attempted for a period longer than the set value, in
seconds, the connection disconnects.
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.
Data type: int
Units: seconds
Default: 60
Range: 0 to java.lang.Short.MAX_VALUE (32767)
If set to 0 (zero), no login timeout is specified. If set to a value more than the specified range such as
330000, the following error message is displayed:
Invalid connection property setting: Provided LoginTimeout property
value 33000 is invalid and should be less than Short.MAX_VALUE(32767).
maxIdleTime Property
Note:
The maxIdleTime property is available in the V11^AAC and subsequent Software Product
Releases (SPRs).
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.
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 –Dt4sqlmx.maxIdleTime=300