allowSRPFallback =
[ true | false ]
|
Allows the driver to fall back to SRP if the TLS connection fails (when used in combination with trustStore ).
|
|
Enables the client to provide one or more appropriate ciphers for encrypting the network connection to the database.
-
If this property is not specified the default ciphers AES-256-CTR and RC4 are enabled. The server chooses a preferred cipher from this list.
-
If no matching cipher is found, the connection will be refused.
-
The cipherlist is comma-separated and cipher names are case-sensitive and must be provided exactly as shown.
-
The full list of available ciphers are AES-256-CTR , RC4 , and None .
|
|
Arbitrary information about the connecting client.
|
|
The process ID (pid ) of the connecting client.
-
The client may set this property only if not already set by the driver.
The .NET and Python drivers set this for the client.
The client setting of this property does not overrides the driver setting of this property.
-
The clientProcessId is then available in the CLIENTPROCESSID column of the SYSTEM.CONNECTIONS and SYSTEM.LOCALCONNECTIONS system tables.
|
|
Connect directly to TE(s) rather than via the AP(s).
-
If not specified, direct defaults to false and connections are made via the AP(s) specified in the connection URL.
-
When direct=true , the client connection is made directly with a TE.
-
The use of the direct connection property is supported for nuosql and the JDBC, C, C++, and Go drivers.
-
Where possible, direct connection should be made using the load-balancing capability of the APs.
-
This connection property is useful when connecting external SQL applications directly to TEs that are running on a different network - such as in the Cloud, on Kubernetes clusters, in Docker or via SSH tunneling.
-
For more details, see Direct TE Connections.
|
|
The maximum time (in seconds) which indicates how long idle connections are left open.
-
Although the IDLE_CONNECTION_TIMEOUT system property is a global setting for timing out idle connections, you can use this connection property to override the system property on a per connection basis.
-
By default, idle-timeout is set to -1 , meaning that the global setting is used.
If you set a value greater than 0 , this property overrides any value set for IDLE_CONNECTION_TIMEOUT .
You may also set a value of 0 to specifically disable this property for the connection.
-
Any time a client connection is terminated for being idle for too long, a message will be logged under the net category.
-
For more information on IDLE_CONNECTION_TIMEOUT , see SQL System Properties.
|
|
The default transaction isolation level for the connection to use.
-
Isolation levels supported are consistent_read and read_committed .
Note that these values are case sensitive.
-
For more information, see CONSISTENT READ and READ COMMITTED.
|
keepAlive =
[ true | false ]
|
Allows enabling of TCP KeepAlive on the connection from client to Transaction Engine (TE).
-
If not specified, keepAlive defaults to false .
-
When keepAlive=true , the driver enables TCP KeepAlive on the socket that it opens to the TE.
|
|
From the client application, this property allows selective load balancing across TEs.
|
LBQuery =<selector>(<filter>)
|
From the client application, this property allows selective load balancing across TEs.
|
lobChunkingEnabled =
[ true | false ]
|
(JDBC only) Enables BLOB and CLOB streaming to the JDBC client.
|
|
(JDBC only) Overrides the default chunk size for BLOB and CLOB streaming.
|
|
The memory limit (per connection) in bytes for all blocking SQL engine operations:
-
Hash-grouping, sorting, sorting via priority queue for limit, distinct (via hash-grouping), union, listagg, table functions, and stored procedures returning result set(s) that accumulate data - in main memory.
-
To run statements with a memory limit different from the system-wide limit, start a new connection with this connection property set to the per-connection limit.
-
If you do not define a value for memory-limit-bytes , the value set for the DEFAULT_CONNECTION_MEMORY_LIMIT system property is the default setting used.
|
|
The password for the user account used to connect to the database.
|
PreferInternalAddress=
[ true | false ]
|
Use internal address and port for TE, as specified by the external-address and external-port process labels.
|
rollbackMode =
[ procedure | transaction | off ]
|
Controls the behavior of transactions executed inside a stored procedure.
|
|
The default schema that the connection should use when objects (such as tables and views) are not fully qualified.
|
|
The default time zone for the connection to use (this is also known as the session time zone).
|
|
Path to file which stores certificates from trusted entities.
|
trustStorePassword =
password
|
Verifies the integrity of the trustsStore.
JDBC only.
|
|
The user name for connecting to the database.
|
verifyHostname =
[ true | false ]
|
Verifies the DN name of the SSL server against the name presented on the certificate. The default is true .
|