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

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” (page 28).
url
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
Default: none
For example:
url=jdbc:t4sqlmx://mynode.mycompanynetwork.net:18000/
url Property Considerations
• If the url parameter is not specified and DriverManager.getConnection() is called,
the Type 4 driver throws an SQLException.
• If you use a literal IPV4 or IPV6 address in a URL, note the following guidelines:
For IPV6 only, enclose the address in brackets ([ and ]).◦
◦ The port number is optional according to both the IPV4 and IPV6 standard.
◦ The default port number for the MXCS association server is 18650.
useArrayBinding
useArrayBinding property improves the performance of the SELECT and INSERT statements.
When this property is set to “true”, the JDBC T4 driver sends/receives multiple rows to/from the
MXOSRVR, which in turn sends/receives information about multiple rows to/from SQL/MX.
This property is ideal for bulk SELECT and INSERT operations.
useArrayBinding property has no influence on UPDATE and DELETE statements.
This property accepts only the following values:
Type 4 Driver Property Descriptions 51