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

T4QueryExecuteLogFile
Whenever the queryExecuteTime is specified, T4QueryExecuteLogFile property is used
to set the name of the logging file for the queryExecuteTime property.
Set this property on a DataSource object, ConnectionPoolDataSource object, or a
DriverManager object.
Data type: String
The default log file name is t4sqlmxQueryExecuteTime.log and will be created
in the user.home directory.
The system can accept any valid file name. If a log file is specified explicitly, it is overwritten each
time a FileHandler is established using that filename.
If a log file that is not fully qualified is specified explicitly, the Type 4 driver creates the file in the
current working directory, for example, in the directory from where the JVM was invoked.
sslEncryption
Starting with H06.27 and J06.16 RVUs, the Type 4 driver supports Secure Sockets Layer (SSL)
encryption for communicating with the ODBC/MX server. SSL and its successor Transport Layer
Security (TLS) are cryptographic protocols that provide communication security over the network.
The Type 4 driver uses the standard Java package (javax.net.ssl) for SSL support. You can
configure SSL encryption using the runtime JVM property, sslEncryption.
To enable SSL encryption, set the sslEncryption property to ON. You can use the command
line and set the property as follows:
-Dt4sqlmx.sslEncryption = ON
You can also set this as a system property in the application using the following method:
system.setproperty(“t4sqlmx.sslEncryption”, “ON”)
NOTE: You cannot set this property on a DataSource object or in the properties file.
Data type: String
The default value is OFF.
NOTE: You must add the server certificate to the client trusted certificates list. Java provides a
built-in list of trusted certificates, and the keytool utility to add a new certificate to the trust store.
You can use the following command to add the certificate to the default Java trust store:
keytool —import —alias <aliasname> —keystore
<jdk-install-location>\jre\lib\security\cacerts
—file <server CA certificate>
You can create a new trust store and use this store at runtime with the following commands:
keytool —import —alias <aliasname> —keystore <truststorename>.jks
—file <server CA certificate>
-Djavax.net.ssl.trustStore=<truststorename>.jks
-Djavax.net.ssl.trustStorePassword=<password>
translationVerification
The translationVerification property defines the behavior of the driver if the driver cannot
translate all or part of an SQL statement or SQL parameter.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
50 Type 4 Driver Properties