The following table summarizes connection properties not included in the preceding topics.

Table 1. Additional Properties
Property Characteristic
ConvertNull Controls how data conversions are handled for null values. If set to 1 (default), a data type check is performed for null column values.
EnableAccessRequestHeader Determines whether the driver enables the access request header for a connection. The access request header contains a token value that, when included in a SOAP request, identifies the current connection among the competing connections to optimize its performance and quality of service.
EnablePagingWithOrderById Specifies whether the driver can inject the Order By clause in the Select query for each JDBC call. If set to true (default), this property provides a stable paging mechanism for retrieving result sets that are larger than the site configured maximum number of rows.
FetchSize Specifies the number of rows that the driver processes before returning data to the application. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.
InitializationString

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.
InsensitiveResultSetBufferSize Determines the amount of memory that is used by the driver to cache insensitive result set data. The default is 2048 (KB of memory).
JavaDoubleToString Determines which algorithm the driver uses when converting a double or float value to a string value. By default, the driver uses its own internal conversion algorithm, which improves performance. The default is false.
LogConfigFile Specifies the file name, and optionally, the path of the properties file used to initialize driver logging.
ManagedObjects Specifies a comma-separated list of managed objects that you want the driver to fetch metadata for. The driver may not fetch metadata for the newly added managed objects by default. Therefore, the Managed Objects connection option must be used to fetch metadata for them.
RefreshDirtyCache Specifies whether the driver refreshes a dirty cache on the next fetch operation from the cache. A cache is marked as dirty when a row is inserted into or deleted from a cached table or a row in the cached table is updated.
TransactionMode Specifies how the driver handles manual transactions.

See also