This table lists the CONNX JDBC connection string parameters that can be used when opening a connection to the CONNX JDBC Driver.
|
Connection Parameter Name |
Description |
|---|---|
|
APPLICATION |
Specifies the CONNX application to use when connecting. The application can be a database within the CDD or within an entire collection of databases. |
|
CLIENTID |
This is a user-defined identifier sent from the CONNX Client to the CONNX Server. It can be used to run custom procedures on the server during a connection. Use of this setting will affection connection pooling, as any identifier used here is part of the unique signature of a connection. |
|
CNXSESSIONID |
This is a user-defined identifier sent from the CONNX Client to the CONNX Server. It can be used to run custom procedures on the server during a connection. Use of this setting will not affect connection pooling. A special CNXSessionID of "BYPASSCAP" will enable connections that exceed the JDBC Maximum parallel connection cap. |
|
DBKEY |
This is an Rdb-only feature. The only valid option is ATTACH. If DBKEY=ATTACH is specified, then Rdb DBKEYS is not reused throughout the lifetime of a connection. |
|
DBREADONLY |
A list of databases in the CDD, separated by commas, which are treated as read only. |
|
DBREADWRITE |
A list of databases in the CDD, separated by commas, which are treated as read/write. |
|
DD |
The name of the JDBC data source. Required. (deprecated) |
|
DSN |
The name of the JDBC data source. Required. |
|
EXCLUSIVE |
Connect to all databases in "exclusive" mode. |
|
GATEWAY |
The name or ID address of the JDBC Server. Required. |
|
NODE |
The name of the server to connect to. This option is only useful when connecting to a CDD that only has one data source in it. |
|
OEM |
Key used for OEM redistributors. |
|
PORT |
The port that the JDBC Server is configured to listen to. The default is 7500. |
|
PASSWORD |
The CONNX password. |
|
PWD |
The CONNX password (deprecated) |
|
READONLY |
This option connects to all databases in the CDD in read only mode. |
|
RPC |
The name of a CONNX RPC to execute right after a connection has been established. |
|
RPCBUFFERSIZE |
The size of the buffer used to send data between the JDBC driver and the JDBC server. The default value is 100000 bytes. |
|
SSL |
Enable TLS/SSL encryption for this JDBC Connection. Valid values are "true" and "false" |
|
UID |
The CONNX UserID (deprecated) |
|
USER |
The CONNX UserID. |
|
VIEWCHECK |
A logical connection is made to the CDD without physically connecting to any of the data sources. All queries will return 0 rows. The defaul value is false. |
.