CONNX JDBC Connection String Parameters

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.

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.

PWD

The CONNX password.

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.

UID

The CONNX UserID.

.