JDBC Type 4 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

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.
●
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 the URL is:
jdbc:t4sqlmx//ip_address|machine_name:port_number/[:]
[property=value[;property2=value]...]
where ip_address|machine_name:port_number specifies the location where the MXCS
association server is running.
Data type: String