JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

The value can be any valid Java Canonical Name as listed in the "Canonical Name for java.io and java.lang API" column of the Oracle
documentation,
Supported Encodings (http://download.oracle.com/javase/1.5.0/docs/guide/intl/encoding.doc.html).
For example, to set the language to shift-JIS, Japanese:
language=SJIS
LOB Table Name Properties
LOB tables store data for BLOB columns and CLOB columns. The properties that specify the LOB table for using BLOB columns or CLOB columns
are:
For the binary data for BLOB columns
blobTableName
For the character data for CLOB columns
clobTableName
The property value is of the form:
catalog_name.schema_name.lob_table_name
Data type: String
Default: none
For example:
blobTableName=samdbcat.sales.lobvideo
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.
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
maxPoolSize Property
The maxPoolSize property sets the maximum number of physical connections that the pool can contain. These connections include both free