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

part of an SQL statement or SQL parameter.
Table 4.5. Logging and Tracing Properties
Property
Name
Description Default Value
T4LogFile Sets the name of the logging file for the Type 4 driver. The name is defined by the following
pattern:
%h/t4sqlmx%u.log
T4LogLevel Sets the logging levels that control logging output for the Type 4
driver.
OFF
Table 4.6. Miscellaneous Client-Side Properties
Property Name Description Default Value
description Specifies the registered source name. None
properties Specifies the location of the properties file that contains keyword-value
pairs that specify property values for configuring the Type 4 driver.
None
roundingMode Specifies the rounding behavior of the Type 4 driver. ROUND_HALF_UP
closeConnectionUponQueryTimeout Specifies the behavior of the JDBC driver when
Statement.setQueryTimeout() is run.
DEFAULT
Server-Side Properties
Type 4 driver properties that effect server-side operations are summarized in the following tables. Unless otherwise noted in the description,
the particular property applies to the
DataSource object, DriverManager object, andConnectionPoolDataSource object.
Table 4.7. Type 4 Driver Server-Side Properties
Property Name Description Default Value
catalog Sets the default catalog used to access SQL objects referenced in
SQL statements if the SQL objects are not fully qualified.
None
connectionTimeout Sets the number of seconds a connection can be idle before the
connection is physically closed by MXCS.
-1 (Use the ConnTimeout value set on
the MXCS server data source.)
password Sets the Guardian password value for to MXCS. empty string
schema Sets the database schema that accesses SQL objects referenced in
SQL statements if the SQL objects are not fully qualified.
None
serverDataSource Sets the name of the data source on the MXCS server side (resides
on the HP NonStop server).
None (This value is treated as the
default server data source.)
url Sets the URL value for the MXCS association server. Can be set only
on the DriverManager object.
None
useArrayBinding Improves the performance of SELECT and INSERT statements. It is a
server side property.
False
user Sets the URL value for the MXCS association server. None
How to Specify JDBC Type 4 Properties
Where To Set Properties
Creating and Using a Properties File
Setting Properties in the Command Line
Precedence of Property Specifications
The Type 4 JDBC driver properties configure the driver. These properties can be specified in a data source, a connection URL, a properties file,
or in the java command line.
Java properties have the form:
key=value
At runtime, the driver looks for a specific set of property keys and takes action based on their associated values.