JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

indicates a detailed tracing message for which internal Type 4 driver methods provide messages. These messages can be useful in
debugging the Type 4 driver.
FINEST
indicates a highly detailed tracing message. The driver provides detailed internal data messages that can be useful in debugging the
Type 4 driver.
ALL
logs all messages.
For example, to enable tracing, use the
t4sqlmx.T4LogLevel property specified in the command line:
-Dt4sqlmx.T4LogLevel=FINE
T4LogLevel Considerations
If a security manager is defined by your application using an AppServer, LoggingPermission must be granted in the java.policy file as
follows:
permission java.util.logging.LoggingPermission "control","";
The Type 4 driver is not designed to inherit the java.util.logging.FileHandler.level settings at program startup.
Server-side tracing and logging through MXCS is managed by NSM/web. For more information about server side-tracing (logging), see the
NSM/web online help.
T4QueryExecuteLogFile Property
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. For information on how to set properties,
see
How to Specify JDBC Type 4 Properties.
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 file
name.
If a log file that is not fully qualified is specified explicitly, the Type4 driver creates the file in the current working directory, for example, in the
directory from where the JVM was invoked.
translationVerification Property
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. For information about how to set
properties, see
How to Specify JDBC Type 4 Properties.
The value can be
TRUE or FALSE.
Data type: String
Default: FALSE
If the translationVerification property’s value is FALSE, and the driver is unable to translate all or part of an SQL statement; the translation is
unspecified. In most cases, the characters that are untranslatable are encoded as ISO88591 single-byte question marks (
? or 0x3F). No
exception or warning is thrown.
If the translationVerification property’s value is TRUE and the driver cannot translation all or part of an SQL statement or parameter, the driver
throws an SQLException with the following text.
Translation of parameter to {0} failed. Cause: {1}
where {0} is replaced with the target character set and {1} is replaced with the cause of the translation failure.
If the
translationVerification property is set to TRUE, the process can use significantly more system resources. For better performance, set
this property to
FALSE.
For more information, see
Internationalization (I18N) Support .
url Property
The url property sets the URL value for the MXCS association server. This property is used in the DriverManager object. The format to specify