Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Driver:jstels.jdbc.dbf.DBFDriver2
Protocolo:jstels
Parámetros:dbf:c:/mydir/dbffiles

Driver Modes

There are two main modes StelsEngine can run in: the mode with data caching and the mode with data swapping. Running in the first mode (default mode), the driver stores all tables in the RAM making it possible to achieve maximum performance. Keep in mind that Java Virtual Machine must have enough free memory allotted for storing large tables (use -Xms and -Xmx JVM options).

The second mode can be used to process large tables which cannot be fully stored in the RAM. To use this mode, set the driver property caching to false. There are also some properties for configuring this mode:

tempPath - directory where temporary files will be created (by default it is a OS temporary directory, specified by JVM environment variable "java.io.tmpdir").

 maxRecordsInMemoryPerTable is used to define how many records should be saved in the RAM for each table (by default - 5000 records).

maxSwapStringSize - default size for string columns in swap files (by default - 50 characters).

Ejemplo de uso de parámetros en el string de conexión: dbf:c:/mydir/dbffiles?caching=false

...

Anchor
Access
Access

Access

Crear ODBC del sistema que apunte a el archivo de access

...