In addition to the standard connection parameters the driver supports a number of additional properties which can be used to specify additional driver behaviour specific to LightDB.
lightdb.jdbc.resultset.raw = int
The maximum number of records that can be stored in a single ResultSet using JVM memory, and when the capacity exceeds this limit, EhCache heap memory will be used, which can be set through environment variables.
The default value is 100000.
lightdb.jdbc.resultset.heap = int
The maximum number of records that can be cached in a single ResultSet using EhCache in-memory, with the capacity exceeding this limit using EhCache out-of-memory, which can be set by an environment variable.
The default value is 100000.
lightdb.jdbc.resultset.offheap = int
The maximum amount of off-heap memory that can be used by a single ResultSet in EhCache, after which capacity exceeds will use EhCache disk files, measured in MB, set by an environment variable.
The default value is 128.
lightdb.jdbc.resultset.disk = int
The maximum disk usage allowed for a single ResultSet enabled by EhCache, measured in GB, can be set via an environment variable.
The default value is 128.