Please enable JavaScript to view this site.

Made in EU
Invantive Estate

Navigation: Invantive SQL > Providers

Provider LoketNl: Loket.nl information.

Loket.nl information.

Code for use in settings.xml: LoketNl

Alias: LoketNl

Status: Production

Available in Editions: Paid

Technical Documentation: https://developer.loket.nl/Introduction

Provider Attributes

The following provider attributes are available for LoketNl:

Code

Description

Default Value

Set from Connection String

Set from Set SQL-Statement

Set from Providers File

environment-code

Environment code.

The environment code signals the unique database to use. The code is a small integer. Please append '@test' to use a test environment located at the test data centre.

 

✓

 

✓

force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

False

✓

✓

✓

forced-casing-identifiers

Forced casing of identifiers. Choose from Unset, Lower, Upper and Mixed.

 

✓

✓

✓

http-disk-cache-compression-level

Compression level for the HTTP disk cache, ranging from 1 (little) to 9 (intense). Default is 5.

5

✓

✓

✓

http-disk-cache-directory

Directory where HTTP cache is stored.

C:\Users\gle3\Invantive\Cache

✓

✓

✓

http-disk-cache-max-age-sec

Maximum acceptable age in seconds for use of data in the HTTP disk cache.

2592000

✓

✓

✓

http-get-timeout-ms

HTTP GET timeout (ms)

300000

✓

✓

✓

http-memory-cache-compression-level

Compression level for the HTTP memory cache, ranging from 1 (little) to 9 (intense). Default is 5.

5

✓

✓

✓

http-memory-cache-max-age-sec

Maximum acceptableage in seconds for use of data in the HTTP memory cache.

14400

✓

✓

✓

http-post-timeout-ms

HTTP POST timeout (ms)

300000

✓

✓

✓

invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

True

✓

✓

✓

invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

False

✓

✓

✓

invantive-use-cache

Whether to cache the results of a query.

True

✓

✓

✓

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

 

✓

✓

✓

partition-slot-based-rate-limit-length-ms

Length in ms of a partition-based rate limit across all slots.

60000

✓

 

✓

partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit

 

✓

 

✓

pre-request-delay-ms

Pre-request delay in milliseconds per request.

0

✓

✓

✓

requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

32

✓

✓

✓

result-set-cache

Action: provide 'empty' to empty.

 

 

✓

 

slot-based-rate-limit-length-ms

Length in ms of a slot-based rate limit across all slots.

60000

✓

 

✓

slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit

 

✓

 

✓

standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

True

✓

✓

✓

standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

True

✓

✓

✓

trace-native-calls

Trace native calls to data container backend.

False

✓

✓

✓

use-http-disk-cache-read

Whether to use HTTP responses from previous queries stored on disk to answer the current query.

True

✓

✓

✓

use-http-disk-cache-write

Whether to memorize HTTP responses on disk.

True

✓

✓

✓

use-http-memory-cache-read

Whether to use HTTP responses from previous queries stored in memory to answer the current query

True

✓

✓

✓

use-http-memory-cache-write

Whether to memorize HTTP responses in memory

True

✓

✓

✓

use-metadata-cache

Whether to use the metadata calculated previously

Has only practical use during development on a XML provider.

True

✓

✓

✓

use-result-cache

Whether to use result sets from previous queries that can answer the current query

True

✓

✓

✓

use-test-environment

OBSOLETED. USE @test INSTEAD.

 

✓

 

✓

 

Generated 04-02-2019 9:03: on version 17.31.23-BETA+1887.

X

<%SAFETY_TITLE%>

<%SAFETY_1%>

  • <%SAFETY_2%>
  • <%SAFETY_3%>
  • <%SAFETY_4%>
  • <%SAFETY_5%>
  • <%SAFETY_6%>
  • <%SAFETY_7%>
  • <%SAFETY_8%>
  • <%SAFETY_9%>

<%SAFETY_USER%>

<%SAFETY_DISCLAIMER%>