JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

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.
Where To Set 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:
-Dt4sqlmx.properties=location_of_the_properties_file_on_disk
For example,
-Dt4sqlmx.properties=C:\temp\t4props
To create the file, use the editor of your choice on your workstation to type in the property values. The
entries in properties file must have a property_name=property_value value-pair format: