JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

catalog
The catalog property sets the default catalog used to access SQL objects referenced in SQL
statements if the SQL objects are not fully qualified.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
Default: none
For example, specifying the catalog samdcat:
catalog=samdcat
clobTableName
See “LOB Table Name Properties” (page 43).
closeConnectionUponQueryTimeout
The closeConnectionUponQueryTimeout property specifies the behavior of the JDBC driver when
Statement.setQueryTimeout() is run.
The values that can be provided for the property closeConnectionUponQueryTimeout are
IGNORE/DEFAULT/ON.
If the property value is set to any value other than the ones mentioned, the value is set to DEFAULT.
The JDBC Driver behaves in accordance to the set value. Listed below are the effects on the JDBC
Driver when the IGNORE, DEFAULT, or ON value is set:
IGNORE = Any value (> 0) set by calling Statement.setQueryTimeout() has no effect. The Statement
continues to block the current thread until the statement is run.
DEFAULT = This is the value set if the property is not specified. Any value (> 0) set by calling
Statement.setQueryTimeout() causes anSQLException to be raised when this property is set to
DEFAULT.
ON = Any value (>0) set by Statement.setQueryTimeout() has the following effect:
If the Statement takes more time than the specified timeout value, the current Connection object is
terminated and an SQLException is raised.
For example, specify the value IGNORE as follows:
closeConnectionUponQueryTimeout=IGNORE
connectionTimeout
The connectionTimeout property sets the number of seconds a connection can be idle before
the connection is physically closed by MXCS.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: int
Units: seconds
Default: -1 (Use the ConnTimeout value set on the MXCS server data source.)
40 Type 4 Driver Properties