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

-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:
property_name=property_value
For example, maxStatements=1024
To configure a DataSource connection, the properties file might contain property names and values
as indicated in the following list:
url=jdbc:t4sqlmx://mynode.mycompanynetwork.net:port_number/
user=NSK_username
password=mypassword
description=a string
catalog=sampcat
schema=myschema
maxPoolSize=20
minPoolSize=5
maxStatements=20
loginTimeout=15
initialPoolSize=10
connectionTimeout=10
serverDataSource=MXCS_server_data_source
T4LogLevel=OFF
T4LogFile=/mylogdirectory/mylogfile
Setting Properties in the Command Line
When a Type 4 driver property is specified on the command line through the java -D option,
the property must include the prefix:
t4sqlmx.
This notation, which includes the period (.), ensures that all the Type 4 driver property names are
unique for a Java application. For example, the maxStatements property becomes:
-Dt4sqlmx.maxStatements=10
Precedence of Property Specifications
If a particular property is set several ways by an application, the value used depends on how the
value was set according to the following order of precedence:
1. Set on the DataSource object, DriverManager object, or ConnectionPoolDataSource
object.
2. Set through the java.util.Properties parameter in the getConnection method of
DriverManager class.
3. Set the property in a properties file specified by the t4sqlmx.properties property.
4. Set the –Dt4sqlmx.property_name=property_value in the java command line
For more information, see order of precedence for properties specified in various ways for use
with the Driver Manager.
Type 4 Driver Property Descriptions
This section discusses the type 4 driver properties. For information on setting the driver properties,
see “Specifying JDBC Type 4 Properties” (page 37).
• “blobTableName” (page 39)
• “catalog” (page 40)
38 Type 4 Driver Properties