JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

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
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 Property
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: