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

initialPoolSize Property
ISO88591 Property
KANJI Property
KSC5601 Property
language Property
LOB Table Name Properties
loginTimeout Property
maxIdleTime Property
maxPoolSize Property
maxStatements Property
minPoolSize Property
networkTimeout Property
password Property
properties Property
queryExecuteTime Property
reserveDataLocators Property
roundingMode Property
schema Property
serverDataSource Property
T4LogFile Property
T4LogLevel Property
T4QueryExecuteLogFile Property
translationVerification Property
url Property
useArrayBinding Property
useExternalTransaction Property
user Property
The properties are listed in alphabetic order (with the exception of LOB Table Name Properties) together with their descriptions.
blobTableName Property
See LOB Table Name Properties.
catalog Property
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. For information about how to set
properties, see
How to Specify JDBC Type 4 Properties.
Data type: String
Default: none
For example, specifying the catalog
samdcat:
catalog=samdcat
clobTableName Property
See LOB Table Name Properties.
closeConnectionUponQueryTimeout Property
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 an
SQLException 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.