JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

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 38)
“Precedence of Property Specifications” (page 38)
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.
Setting Properties
• For connections made through a DataSource or a ConnectionPoolDataSource, set the
property on the DataSource or the ConnectionPoolDataSource object.
• For the DriverManager class, set properties in either of two ways:
Using the option -Dproperty_name=property_value in the command line◦
◦ Using the java.util.Properties parameter in the getConnection() method of
the DriverManager class
Creating and Using a Properties File
JDBC applications can provide property values to configure a connection by using a file that
contains properties for the JDBC driver. This property file is passed as a java command-line
parameter. The format to enter the properties file in the command line is:
Specifying JDBC Type 4 Properties 37