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

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:
true
false
Data Type: String
Default: false
For example, specify the value true as
useArrayBinding = true