skip to main content
Using the Driver : Configuring and Connecting to Data Sources : Data Source Configuration Using a GUI : Advanced Tab
  

Try DataDirect Drivers Now
Advanced Tab
The Advanced Tab allows you to specify additional data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.
Figure 3. Advanced tab
The Advanced Tab of the ODBC Driver for Cassandra Setup dialog box
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
Extended Options: Type a semi-colon separated list of connection options and their values. Use this configuration option to set the value of undocumented connection options that are provided by Progress DataDirect Customer Support. You can include any valid connection option in the Extended Options string, for example:
KeyspaceName=mykeyspace;UndocumentedOption1=value [;UndocumentedOption2=value;]
If the Extended Options string contains option values that are also set in the setup dialog or data source, the values of the options specified in the Extended Options string take precedence. However, connection options that are specified on a connection string override any option value specified in the Extended Options string.
If you finished configuring your driver, proceed to Step 6 in "Data Source Configuration on Windows." Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:
*General tab allows you to configure options that are required for creating a data source.
*SQL Engine tab allows you to configure the SQL Engine's behavior.
*Schema Map tab allows you to configure mapping behavior.
*Security tab allows you to configure security settings.