skip to main content
Using the Driver : Using Connection Properties : Additional Properties
  

Try DataDirect Drivers Now

Additional Properties

The following table summarizes additional connection properties.
Table 22. Additional Properties
Property
Characteristic
Specifies the number of rows that the driver processes before returning data to the application when executing a Select. This value provides a suggestion to the driver as to the number of rows it should internally process before returning control to the application. The driver may fetch fewer rows to conserve memory when processing exceptionally wide rows.
Specifies 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 throws an exception indicating which SQL command or commands failed.
Determines the amount of memory used by the driver to cache insensitive result set data.
Specifies the filename of the configuration file used to initialize driver logging.
The amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request.
Specifies the number of rows of data the driver attempts to fetch from the native data source on each request submitted to the server.
Specifies how many replicas must respond to a read request before returning data to the client application.
Specifies whether the connection supports read-only access to the data source.
Specifies the maximum size, in megabytes, of an intermediate result set that the driver holds in memory. When this threshold is reached, the driver writes a portion of the result set to disk in temporary files.
Enables DataDirect Spy to log detailed information about calls issued by the driver on behalf of the application. DataDirect Spy is not enabled by default.
Specifies how the driver handles manual transactions.
Determines the number of replicas on which the write must succeed before returning an acknowledgment to the client application.