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

Default: none
For example:
blobTableName=samdbcat.sales.lobvideo
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
loginTimeout
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.
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
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 must
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.
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
maxPoolSize
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.
Data type: int
Type 4 Driver Property Descriptions 43