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

Try DataDirect Drivers Now
Additional Properties
The following table summarizes connection properties not included in the preceding topics.
Table 7. Additional Properties
Property
Characteristic
Controls how data conversions are handled for null values. If set to 1 (default), a data type check is performed for null column values.
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.
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.
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.
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 that is used by the driver to cache insensitive result set data. The default is 2048 (KB of memory).
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.
Specifies the file name, and optionally, the path of the properties file used to initialize driver logging.
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.
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.
Specifies how the driver handles manual transactions.

See also

*Connection Property Descriptions
*Performance Considerations