JDBC Type 4 Driver 1.1 Programmer's Reference
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:
Set on the DataSource object, DriverManager object, or
ConnectionPoolDataSource object.
1.
Set through the java.util.Properties parameter in the getConnection
method of DriverManager class.
2.
Set the property in a properties file specified by the t4sqlmx.properties property.3.