LexEVS 6.0 Local Runtime Configuration File Settings

Below you will find an expanded overview of the options in this file. Options in BOLD must be modified so that LexEVS can properly use your database. They are also noted as required. There are many other options that you can change for performance reasons or alternative deployment scenarios, but you probably don't need to change them in a standard LexEVS installation. Some options can not be changed after you load terminologies into LexEVS. Now would be a good time to read about what is available to you.

Note

A single back slash "\" is not valid within the lbconfig.props file for file or directory paths (except within JDBC connection strings). When constructing file or directory paths you must use either a forward slash "/" or two backward slashes.

Property Name	Description
`CURRENT_PERSISTENCE_SCHEME`	The current persistence scheme used to persist to an underlying store. This should remain unchanged unless there are custom persistence layers implemented. Default is set to 2.0
`DB_URL`	Required: The address of your database server. This will include the host name or IP address followed by the name of the database that you created to store LexEVS data. For example: DB_URL=jdbc:mysql://{hostname}/{DBNAME} ...where `hostname` is the name of your server or `hostand DBNAME` is the name of the database you created for LexEVS within your database software `hostname` can also be an IP address `hostname` can also be followed by a colon and a port number in the case where you have multiple installs on the same server and have changed the port number that the database responds to. There are several options in the file as an example.
`DB_PREFIX`	The prefix to use on created tables. Warning If you are using Oracle, this is not supported because of length constraints on oracle table names so you must leave this value blank. On databases other than Oracle, there should be room for a reasonable (< 10) amount of characters. This value MUST BE UNIQUE for each LexEVS runtime that uses the same database host. Do not use dashes `-` in the db_prefix value. Recommended characters are alphanumeric (a-z, 0-9) and underscore _. This variable should typically not be changed after content has been loaded. The default is `lb`.
`DB_PRIMARY_KEY_STRATEGY`	Primary key strategy indicates which strategy will be used for the primary key of the database tables. Warning This cannot be changed after the initial schema installation. Allowable values include: `GUID` Primary Keys are implemented as random GUIDs. `SEQUENTIAL_INTEGER` Primary Keys will be sequentially incremented as Integer values. Starting in 6.0.4 this is the default. Sequential Integer Primary Key (SEQUENTIAL_INTEGER) is the best strategy for large loads. This allows the database to insert records into the index in a sequential manner, which is more efficient. If the GUID strategy is used, records will be inserted into the index tree at random locations, resulting in index re-balancing after every insert.
`DB_PARAM`	Optional variable for passing extra database parameters. These will be appended to the end of the database connection string.
`DB_DRIVER`	Required: The Java class name that represents the driver that you wish to use with your database. There are several options in the file as an example.
`DB_USER`	Required: The database username. This account must have permission to add and remove tables, indexes, etc inside of this database. This account is typically created during the installation of the database software and is not necessarily a system user ID.
`DB_PASSWORD`	Required: The password for the database username.
`DB_PASSWORD_ENCRYPTED`	Password encryption can be enabled by setting `DB_PASSWORD_ENCRYPTED` to true (case insensitive). Default and any value other than `true` is interpreted as `false`.
`SINGLE_TABLE_MODE`	Warning READ THE NEXT LINES CAREFULLY SINGLE_TABLE_MODE indicates whether or not all loaded ontologies will be loaded to a single, common set of tables, or partitioned to one ontology per set of tables. `true` - all ontologies in one common set of tables. Default is set to `true`. `false` - each ontology in a seperate set of tables. Setting single table mode to true may result in long delays during the removal of a large terminology. \\\\
`LG_CONFIG_FILE`	This is not actually a variable that you would set within this file. It is documented here for clarity of other variables that depend on this variable. Normally, this variable is automatically set (at runtime) to the location of the lbconfig.props file that is being used by the runtime. Alternatively, you can set the java system variable `LG_CONFIG_FILE` at system startup to point to the lbconfig.props file that you want LexEVS to use. Refer to additional documentation in the `lbconfig.props` file if you need to use this feature.
`LG_BASE_PATH`	This variable is the path that will be used to resolve any other relative (or unqualified) paths in the lbconfig.props file. This variable is optional, and should usually be left blank. If this variable is left blank, it will automatically be set (at runtime) to the location of the folder which contains the lbconfig.props file that the system was started with. This variable can also be overridden by setting the java system variable `LG_BASE_PATH`. The default value is blank.
`JAR_FILE_LOCATION`	The path of the folder that contains your SQL drivers and LexEVS extensions (if you have any). This value can be relative to the `LG_BASE_PATH` or absolute. The default is `../../runtime`
`REGISTRY_FILE`	This value is only here for backwards compatibility. It is not needed in versions beyond 6.x. The location of the file that will store information about all loaded terminologies. This value can be relative to the `LG_BASE_PATH` or absolute. The default is `registry.xml`.
`INDEX_LOCATION`	The folder where all LexEVS generated indexes will be stored. This folder can potentially be large (100+ GB) - depending on the terminologies loaded. This value can be relative to the `LG_BASE_PATH` or absolute. The default is `../lbIndex`.
`MAX_CONNECTIONS_PER_DB`	LexEVS maintains a pool of connections to each database that it connects to. This sets the limit on the number of connections that will be opened. You may want to set this to a higher value - 20 or so (depending on expected user load) The default is 25.
`CACHE_SIZE`	LexEVS maintains an internal cache of some information that it needs to query from the database to resolve queries. This controls the size of that cache. This cache does not hold entire user queries. The default size is 500.
`ITERATOR_IDLE_TIME`	The length of time to allow an unused (and unclosed) iterator to stay valid before it is closed (and its resources freed) by the system. The default is 5 minutes.
`MAX_RESULT_SIZE`	This controls the maximum number of results that a user can resolve at one time for the CodedNodeSets and CodedNodeGraphs. This does not affect the total number of results that can be returned by an iterator, just the size that can be returned on the `next` API call. The default is 1000.
`LUCENE_MAX_CLAUSE_COUNT`	The number of boolean `clauses` Lucene will attempt to create for wildcard or Regular Expression queries. For very general queries on large ontologies, this will need to be set high. The default is 40000.
`LOG_FILE_LOCATION`	The path where LexEVS log files will be written. This value can be relative to the `LG_BASE_PATH` or absolute. The default is `../../logs`.
`API_LOG_ENABLED`	Setting API call logging to `true` will cause every method call to be printed to the log file. The default is `false`.
`SQL_LOG_ENABLED`	Setting SQL logging to `true` will cause every sql statement executed to be printed to the log file. The default is `false`.
`DEBUG_ENABLE`	Setting debug to `true` will give you more verbose logging information to debug problems. This should normally be set to `false` since debug logging causes a negative performance impact. The default is `false`.
`LOG_CHANGE`	Indicates when a new log file should be started. This can be set to `monthly`, `weekly` or `daily`. This can also be set to a number which will cause it to start a new log file whenever it reaches the specified number of MB in size. The default is 5 MB.
`ERASE_LOGS_AFTER`	If LOG_CHANGE is set to `daily`, `weekly`, or `monthly`, this variable instructs the logging service to remove log files that have not been written to in the specified amount of days. If LOG_CHANGE is set to a number of MB then this variable specifies the number of old log files that will be kept. The unit is treated as days regardless of the LOG_CHANGE value. Cleanup will only occur on restart of the JVM. The default is 5 files.

Content

Space Tools