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

networkTimeout Property
The networkTimeout property sets a time limit that the driver waits for a reply from the database server. When an operation is attempted for a
period longer than the set value, in seconds, the driver stops waiting for a reply and returns an
SQLException to the user application.
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.
Note: Be careful when using this property. A network timeout causes the socket connection between the Type 4 driver
and the MXCS server to timeout. If the server is engaged in a transaction or an SQL operation, then the server
continues to perform that transaction or operation until the transaction or operation fails, TMF times out, or the
server realizes that the Type 4 driver client has gone away. A network timeout can result in an open transaction or
operation that continues for a significant time before failing or rolling back.
As a result of a network timeout, the connection becomes unavailable.
Data type: int
Units: seconds
Default: 0 (No network timeout is specified.)
0 through to 2147483647
password Property
The password property sets the Guardian password value for to MXCS. The password is encrypted when it is passed to MXCS.
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: empty string
For example:
password=eye0weU$s
properties Property
The properties property specifies the location of the properties file that contains keyword-value pairs that specify property values for configuring
the
Type 4 driver. For more information, see Creating and Using a Properties File.
queryExecuteTime Property
This property is used to specify the value in time (milliseconds). Any query that takes more than the specified time will be logged in the log file.
If this property is specified, a separate log file is created. The default log file name is
t4sqlmxQueryExecuteTime.log and will be created in the
user.home directory.
If you want to explicitly specify a log file, see the
T4QueryExecuteLogFile property.
Set this property on a
DataSource object, ConnectionPoolDataSource object, or a DriverManager object. For information on how to set
properties, see
How to Specify JDBC Type 4 Properties.
Data type: int
Units: Number of milliseconds
Default: None
Range: 1 to 9,223,372,036,854,775,807 (2**63-1)
For example:
java -Dt4sqlmx.queryExecuteTime = 10
reserveDataLocators Property
The reserveDataLocators property sets the number of data locators to be reserved for a process that stores data in a LOB table.
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: number of data locators to be reserved
Default: 100
Range: 1 to 9,223,372,036,854,775,807 (2**63 -1)
Do not set a value much greater than the number of data locators actually needed. If the specified value is 0 (zero) or less, the default value
(100) is used.
Base the setting of the value of the
reserveDataLocators property on the application profile being run. If the application inserts a large number of
reserveDataLocators