JDBC Type 4 Driver Programmer's Reference

Other NonStop JDBC Type 4 Driver properties:
loginTimeOut●
datasourceName●
description●
catalog
Sets the database catalog for the MXCS connection. For more information, see the SQL/MX Connectivity Services Manual.
schema
Sets the database schema for the MXCS connection. For more information, see the SQL/MX Connectivity Services Manual.
url
Sets the URL value for the MXCS association server. The format to specify the URL is:
jdbc:t4sqlmx//ip_address|machine_name:port_number
ip_address|machine_name:port_number specifies the location where the MXCS association server is running.
Using an IPV6 address in a URL
You can use a literal IPV6 address in a URL with the following considerations:
Enclose the address in brackets ("[" and "]").●
Port number is optional, per the IPV6 standard.●
The default port number for the MXCS association server is 18650.●
user
Sets the Guardian user name value for connecting to MXCS. The default user name is the empty string. The Guardian user name passed
must have adequate access permissions for SQL/MX data accessed through MXCS.
password
Sets the Guardian password value for connecting to MXCS. The default password is the empty string. The password is encrypted when it
is passed to MXCS.
maxStatements Property
Sets the total number of PreparedStatement objects that the connection pool should cache. This total includes both free objects and
objects in use. Specify the maxStatements property as:
int
The integer can be 0 through n. 0 disables statement pooling. Any negative value is treated like 0. The default is -1, which disables
statement pooling. HP recommends that you enable statement pooling for your JDBC applications, because this pooling can dramatically
help the performance of many applications.
minPoolSize Property
Limits the number of physical connections that can be in the free connection pool. Specify the minPoolSize property as:
int
The integer can be 0 through n, but less than maxPoolSize. The default is 0. Any negative value is treated like 0. Any value greater
than maxPoolSize is changed to the maxPoolSize value. This value is ignored when maxPoolSize is -1. The value determines
connection pool use as follows:
When the number of physical connections in the free pool reaches the minPoolSize value, the Type 4 driver closes subsequent●