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

Table 8 Miscellaneous Client-Side Properties (continued)
Default ValueDescriptionProperty Name
ROUND_HALF_UPSpecifies the rounding behavior of the Type 4 driver.roundingMode
DEFAULTSpecifies the behavior of the JDBC driver when
Statement.setQueryTimeout() is run.
closeConnectionUponQueryTimeout
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, and ConnectionPoolDataSource object.
Table 9 Type 4 Driver Server-Side Properties
Default ValueDescriptionProperty Name
NoneSets the default catalog used to access SQL objects referenced
in SQL statements if the SQL objects are not fully qualified.
catalog
-1 (Use the ConnTimeout value set
on the MXCS server data source.)
Sets the number of seconds a connection can be idle before
the connection is physically closed by MXCS.
connectionTimeout
empty stringSets the Guardian password value for to MXCS.password
NoneSets the database schema that accesses SQL objects
referenced in SQL statements if the SQL objects are not fully
qualified.
schema
None (This value is treated as the
default server data source.)
Sets the name of the data source on the MXCS server side
(resides on the HP NonStop server).
serverDataSource
NoneSets the URL value for the MXCS association server. Can be
set only on the DriverManager object.
url
FalseImproves the performance of SELECT and INSERT statements.
It is a server side property.
useArrayBinding
NoneSets the URL value for the MXCS association server.user
Specifying JDBC Type 4 Properties
“Setting Properties” (page 37)
“Creating and Using a Properties File” (page 37)
“Setting Properties in the Command Line” (page 37)
“Precedence of Property Specifications” (page 37)
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.
36 Type 4 Driver Properties