Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Implement unfinished query options

Description

  • blockfactor (implemented as fetchsize, aliased as blockfactor in the bx-compat module.)

  • dbtype (After query of queries is done)

  • username/password

Cache Options (see #BL-256)

  • cachedAfter and cachedWithin (implemented as timeout and lastAccesstimeout, with bx-compat support for the old names)

  • cacheKey (with bx-compat support for the name cacheId)

  • cacheProvider (with bx-compat support for the name cacheRegion)

If Requested

  • clientInfo

  • fetchClientInfo

Lucee Only

We will not implement unless requested

  • lazy

  • timezone

  • psq

Activity

Show:

Michael Born @ Ortus November 20, 2024 at 1:38 PM

the remaining query options will only be implemented upon request.

Luis Majano November 20, 2024 at 11:11 AM

what is missing in this ticket?

Michael Born @ Ortus June 30, 2024 at 10:33 AM

If we end up implementing the timezone option, here’s a mostly-working test I wrote up which currently refuses to fail:

Michael Born @ Ortus May 28, 2024 at 3:40 PM

We now support a new fetchsize query option, with an alias to blockfactor in the bx-compat module.

This supports altering the default fetch result size to improve performance on large queries:

The returned query result contains the same number of rows, but under the hood the JDBC driver will select rows in batches of 100.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Fix versions

Priority

Parent

Sentry

Created May 22, 2024 at 2:34 PM
Updated November 20, 2024 at 1:38 PM
Resolved November 20, 2024 at 1:38 PM