JDBC Driver for Reckon Accounts Hosted

Build 24.0.9175

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
PollingIntervalThis determines the polling interval in milliseconds to check whether the result is ready to be retrieved.
AsyncTimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
CustomFieldModeWhich nested data format (XML,JSON) custom fields should be displayed in.
IncludeLineItemsWhether or not to request Line Item responses from Reckon Accounts Hosted when retrieving a base transaction, such as Invoices.
IncludeLinkedTxnsWhether or not to request Linked Transactions from Reckon Accounts Hosted when retrieving a base transaction, such as Invoices.
BatchSizeSpecifies the maximum number of rows included in each batch operation. Set to 0 to submit the entire batch as a single request.
ConnectionLifeTimeSpecifies the maximum lifetime of a connection in seconds. When the specified time elapses, the provider closes the connection. Set to 0 or leave empty for no time limit.
ConnectOnOpenSpecifies whether the provider establishes a connection to Reckon Accounts Hosted immediately upon opening the connection. The default value is false. Enable this property only if immediate connectivity verification is necessary.
MaxRowsSpecifies the maximum rows returned for queries without aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties.
PagesizeSpecifies the maximum number of results to return from Reckon Accounts Hosted, per page. This setting overrides the default page size set by the datasource, which is optimized for most use cases.
PoolIdleTimeoutSpecifies the maximum idle time, in seconds, that a connection can remain in the pool before being closed.
PoolMaxSizeSpecifies the maximum number of connections allowed in the connection pool. The default value is 100. Set to 0 or a negative value to disable pooling.
PoolMinSizeSpecifies the minimum number of connections maintained in the connection pool. The default value is 1.
PoolWaitTimeSpecifies the maximum number of seconds a connection request waits for an available connection in the pool. If the wait exceeds this time, an error is returned. The default is 60 seconds.
PseudoColumnsSpecifies the pseudocolumns to expose as table columns. Use the format 'TableName=ColumnName;TableName=ColumnName'. The default is an empty string, which disables this property.
ReadonlyToggles read-only access to Reckon Accounts Hosted from the provider.
RTKSpecifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. The default is 60 seconds. Set to 0 to disable the timeout.
UseConnectionPoolingEnables the connection pooling feature, which allows the provider to reuse existing connections instead of creating new ones for each request.
UserDefinedViewsSpecifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175