Connection Options: Advanced
|
Description
|
Determines whether the driver creates the internal files required for a relational view of the native data when establishing a connection.
If set to 0 - No, the driver uses the current group of internal files specified by the Schema Map connection option. If the files do not exist, the connection fails.
If set to 1 - ForceNew, the driver deletes the current group of files specified by the Schema Map connection option and creates new files in the same location.
If set to 2 - NotExist, the driver uses the current group of files specified by the Schema Map connection option. If the files do not exist, the driver creates them.
Default: 2 - NotExist
|
|
Specifies how the driver handles manual transactions.
If set to 0 - No Transactions, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.
If set to 1 - Ignore, the data source does not support transactions and the driver always operates in auto-commit mode.
Default: 0 - No Transactions
|
|
Specifies how many replicas must respond to a read request before returning data to the client application.
If set to 1 - one, data is returned from the closest replica. This setting provides the highest availability, but increases the likelihood of stale data being read.
If set to 4 - quorum, data is returned after a quorum of replicas has responded from any data center.
If set to 5 - all, data is returned to the application after all replicas have responded. This setting provides the highest consistency and lowest availability.
Default: 4 - quorum
|
|
Determines the number of replicas on which the write must succeed before returning an acknowledgment to the client application.
If set to 1 - one, a write must succeed on at least one replica node.
If set to 4 - quorum, a write must succeed on a quorum of replica nodes.
If set to 5 - all, a write must succeed on all replica nodes in the cluster for that partition key. This setting provides the highest consistency and lowest availability.
Default: 4 - quorum
|
|
Determines whether the driver works with applications using multiple ODBC threads.
If disabled, the driver does not work with multi-threaded applications. If using the driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.
If set to enabled, the driver works with single-threaded and multi-threaded applications.
Default: Enabled
|
|
Specifies whether the connection has read-only access to the data source.
If enabled, the connection has read-only access.
If disabled, the connection is opened for read/write access, and you can use all commands supported by the product.
Default: Disabled
|
|
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
Default: 15
|
|
Specifies the number of rows that the driver processes before returning data to the application when executing a Select.
If set to 0, the driver fetches and processes all of the rows of the result before returning control to the application.
If set to x, the driver limits the number of rows that may be processed and returned to the application for a single fetch request.
Default: 100
|
|
Specifies the number of rows of data the driver attempts to fetch from the native data source on each request submitted to the server.
If set to 0, the driver requests that the server return all rows for each request submitted to the server. Block fetching is not used.
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows on each request submitted to the server.
Default: 10000
|
|
Specifies the maximum size, in megabytes, of an intermediate result set that the driver holds in memory.
If set to -1, the maximum size of an intermediate result set that the driver holds in memory is determined by a percentage of the max Java heap size. When this threshold is reached, the driver writes a portion of the result set to disk.
If set to 0, the driver holds intermediate results in memory regardless of size. Setting Result Memory Size to 0 can increase performance for any result set that can easily fit within the JVM's free heap space, but can decrease performance for any result set that can barely fit within the JVM's free heap space.
If set to x, the driver holds intermediate results in memory that are no larger than the size specified. When this threshold is reached, the driver writes a portion of the result set to disk.
Default: -1
|
|
Specifies how the driver handles code page conversion errors that occur when a character cannot be converted from one character set to another.
If set to 0 - Ignore Errors, the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error.
If set to 1 - Return Error, the driver returns an error instead of substituting 0x1A for unconverted characters.
If set to 2 - Return Warning, the driver substitutes 0x1A for each character that cannot be converted and returns a warning.
Default: 0 - Ignore Errors
|
|
Specifies the filename of the configuration file used to initialize the driver logging mechanism.
Default: ddlogging.properties
|
|
One or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver returns an error indicating which SQL command or commands failed.
Default: None
|