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

• “T4LogLevel” (page 49)
• “T4QueryExecuteLogFile” (page 50)
• “translationVerification” (page 50)
• “url” (page 51)
• “useArrayBinding” (page 51)
• “useExternalTransaction” (page 52)
• “user” (page 52)
• autoCommit
The properties are listed in alphabetic order (with the exception of LOB Table Name Properties)
together with their descriptions.
blobTableName
See “LOB Table Name Properties” (page 42).
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 42).
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
Type 4 Driver Property Descriptions 39