The following table summarizes additional connection properties.

Table 1. Additional Properties
Property Characteristic
FetchSize Specifies the maximum number of rows that the driver processes before returning data to the application for a single fetch request when executing a Select. This value provides a suggestion to the driver as to the number of rows that should be returned to the application. The driver may fetch fewer rows to conserve memory when processing exceptionally wide rows.
InitializationString 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.
LogConfigFile Specifies the filename of the configuration file used to initialize driver logging.
LoginTimeout Determines the amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request.
ReadOnly Specifies whether the connection has read-only access to the data source.
ReadPreference Specifies a preference for the type of member (server node) of a replica set to which the driver attempts to connect.
ResultMemorySize 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.
SpyAttributes Enables DataDirect Spy to log detailed information about calls that are issued by the driver on behalf of the application. DataDirect Spy is not enabled by default.
TransactionMode Specifies how the driver handles manual transactions.

See also