4.B.1.1.1. usedb.fetch-record-count
Specifies the number of records retrieved in one piece, from the database. By default, read the 50 records.
4.B.1.1.2. usedb.cache-record-count
The parameter specifies the number of records buffered by the Query object. By default, the 200th.
All records are read from the database are stored in special files on the disk in the user's temporary directory. They are automatically deleted if not needed. The number, as determined by this parameter allows you to reduce the readings from the disk when you search, sort and move between records in the programs.
4.B.1.1.3. usedb.statement-fetch-size
The parameter lets you specify, buffered by the JDBC driver, the number of records. The function that is called a Statement.setFetchSize() and according to the JDBC documentation is only a hint to the driver.
In some cases (JDBC Oracle), setting this option can cause performance problems retrieving data from server and driver stability problems.
For MySQL JDBC driver, setting it to -1, in accordance with the documentation, it may restrict the use of memory.
4.B.1.1.4. usedb.statement-max-rows
A parameter to specify the maximum number of records to be retrieved by the JDBC driver after the SQL command.
Some JDBC drivers (eg, Jaybird, MySQL), after the execution of SQL commands, cached all records in the memory. This parameter allows to limit the list of records in memory.
4.B.1.1.5. usedb.call-prepare-statement
Parameter, prepare and then execute, INSERT, UPDATE, and DELETE statements with parameters, with call of the JDBC prepareStatement.
Setting the true will cause execution of the above commands in a manner inconsistent with the JDBC specification, but it solves a specific problem Jaybird driver for Firebird database.
4.B.1.1.6. usedb.auto-command-quoted-name
Parameter (default true), specifies a way to create column names in the commands generated automatically. Automatically generated commands are created by the mechanism BufferedRecord.
Setting this parameter to "false" solves the problem of non-compliance with ANSI SQL, for example, some Jaybird JDBC drivers for database Firebird.
4.B.1.1.7. usedb.escape-processing
This allows for commands without parameters (named or ?) set the ExcapeProcessing property