JDBC Driver for QuickBooks Online

Build 24.0.9175

AutoCache

Specifies whether the content of tables targeted by SELECT queries is automatically cached to the specified cache database.

Data Type

bool

Default Value

false

Remarks

When this connection property is set to True, the driver automatically caches the contents of tables targeted by SELECT queries. The content of these tables is cached to the cache database specified by the CacheConnection and CacheDriver connection properties.

See Also

  • CacheMetadata: With CacheMetadata enabled, all retrieved metadata is mirrored in the cache database. This means that any subsequent attempts by the driver to discover metadata are much faster, as this metadata is then read directly from the cache database, without needing to spend time requesting metadata from QuickBooks Online.
  • Explicitly Caching Data: This section provides examples for using AutoCache in Offline mode.
  • CACHE Statements: You can use the CACHE statement to explicitly cache the content of any table targeted by a SELECT query.

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