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.