The Hibernate dialect to use when generating SQL commands to the database. Use:

Other dialects may work but are not supported.

The connection URL that locates the BASE database. The exact syntax of the string depends on the JDBC driver. Here is an example which leaves all other settings to their defaults:

You can get more information about the parameters that are supported on the connection URL by reading the documentation from PostgreSQL.

The name of the catalog where the dynamic database used to store analysed data is located. If not specified the same catalog as the regular database is used. The exact meaning of catalog depends on the actual database. PostgreSQL does not support connecting to multiple databases with the same connection so this should have the same value as the database in the db.url setting.

The name of the schema where the dynamic database used to store analysed data is located. PostgreSQL supports schemas and we recommend that the dynamic part is created in it's own schema to avoid mixing the dynamic tables with the regular ones.

The username to connect to the database. The user should have full permission to both the regular and the dynamic database.

The password for the user.

The batch size to use when inserting/updating items with the Batch API. A higher value requires more memory, a lower value degrades performance since the number of database connections increases. The default value is 50.

The location of an XML file which contains database-specific queries overriding those that does not work from the /common-queries.xml file. Use:

See also Section H.1, “mysql-queries.xml and postgres-queries.xml”.

The location of an XML file describing the extended properties for extendable item types, ie. the reporters. The default value is /extended-properties.xml. See Appendix C, extended-properties.xml reference for more information about extended properties.

The location of an XML file describing all raw data types and their properties. The default value is /raw-data-types.xml. See Appendix D, Platforms and raw-data-types.xml reference for more information about raw data types.

Interval in hours between database cleanups. Set this to 0 to disable (recommened for job agents). The default value is 24. The cleanup will remove entries in the database that have been orphaned due to other information that has been removed. For example, change history entries, any-to-any links and permission keys.

If this setting is 1 or TRUE, BASE will synchronize the extra information (name, address, email, etc.) sent by the authentication manager when a user logs in to BASE. This setting is ignored if the manager does not provide extra information.

If passwords should be cached by BASE or not. If the passwords are cached a user may login to BASE even if the external authentication server is down. The cached passwords are only used if the external authentication does not answer properly.

How many days a cached password is valid if caching is enabled. A value of 0 caches the passwords forever.

If 0 or FALSE the internal job queue will be disabled.

If 1 or TRUE the internal job queue will ignore the useInternalJobQueue flag specified on plug-ins. If 0 or FALSE the internal job queue will only execute plug-ins which has useInternalJobQueue=true

A class implementing the SignalReceiver interface. The class must have a public no-argument constructor. If no value is specified the default setting is: net.sf.basedb.core.signal.LocalSignalReceiver.

Change to net.sf.basedb.core.signal.SocketSignalReceiver if the internal job queue must be able to receive signals from outside this JVM.

Initialisation string sent to SignalReceiver.init(). The syntax and meaning of the string depends on the actual implementation that is used. Please see the Javadoc for more information.

The number of seconds between checks to the database for jobs that are waiting for execution.

Maximum number of threads to reserve for jobs with a given expected execution time. A job with a short execution time may use a thread from one of the slots with longer execution time. When all threads are in use, new jobs will have to wait until an executing job has finished.

The priority to give to jobs. The priority is a value between 1 and 10. See http://download.oracle.com/javase/6/docs/api/java/lang/Thread.html for more information about thread priorities.

Number of seconds to keep job agent information in the internal cache. The information includes, CPU and memory usage and the status of executing jobs. This setting controls how long the information is kept in the cache before a new request is made to the job agent. The default value is 60 seconds.

The timeout in milliseconds to wait for a response from a job agent when sending a request to it. The default timeout is 1000 milliseconds. This should be more than enough if the job agent is on the internal network, but may have to be increased if it is located somewhere else.

A boolean value that specifies if the Change history tab should be visible in the web interface or not. The change history tab will show log information that has been stored in the database and it doesn't make sense to show this tab unless the Database log manager has been enabled.

	Note
	By default, only users that are members of the Administrator role have permission to view the change history. To give other users the same permission, add the Change history permission to the appropriate role(s).

A boolean value that specifies the amount of information that should be logged by the database log manager. If set, the log will contain information about which properties that was modified on each item, otherwise only the type of change (create, update, delete) is logged.

The host name of the SMTP server to use for outgoing mail. If not configured mailing functions will be disabled.

The port the SMTP server is listening on. If not configured a default port is used. Eg. 25 for regular mail server, 465 for SSL mail server.

A boolean value that specifies if the SMTP server is using SSL or not.

A boolean value that specifies if the SMTP server is using TLS or not.

The email address that will be used as the sender of outgoing emails. If not configured mailing functions will be disabled.

Thename that will be used as the sender of outgoing emails. If not configured, a default name is automatically generated using the host name of the BASE server.

The path to the directory where jar-files for external plug-ins and extensions are located. All new plug-ins and extensions found in this directory, can be selected for installation, see Section 22.1, “Managing plug-ins and extensions”.

Enable this setting to let BASE detect if a plug-in JAR file is changed and automatically load and use the new code instead of the old code. This setting is useful for plug-in developers since they don't have to restart the web server each time the plug-in is recompiled.

Note that extensions doesn't support this feature. Use the installation wizard to update an extension.

A boolean flag that, if set, disables all external extensions. Plug-ins or core extensions will never be disabled.

The title that is displayed in the browser tab. Use $VERSION to include the current BASE version and $SERVER to include the server name.

The path to the directory where uploaded and generated files should be stored. This is the primary file storage. Files are not stored in the same directory structure or with the same names as in the BASE file system. The internal structure may contain sub-directories.

Number of minutes to cache a logged in user's permissions before reloading them. The default value is 10. This setting affect how quickly a changed permission propagate to a logged in user. Permissions are always reloaded when a user logs in.

Number of minutes to keep user sessions in the internal cache before the user is automatically logged out. The timeout is counted from the last access made from the user.

If the static cache should be enabled or disabled. It is enabled by default. Disabling the static cache may reduce performance in some cases. The static cache is used to cache processed information, for example images, so that the database doesn't have to be queried on every request.

The maximum age in days of files in the static cache. Files that hasn't been accessed (read or written) in the specified amount of time are deleted.

Defines if already existing helptexts in BASE should be overwritten when updating the program, Section 21.1, “Upgrade instructions”

Configure the server to a specific locale. The language and country should be valid ISO codes as specified by the java.util.Locale documentation. The variant can be any value that is valid as part of a filename.

	Note
	Note that language codes are usually lower-case but country codes are upper case. Eg. sv is the language code for swedish, and SE is the country code.

This configuration can be used to provide translations to some parts of the web gui. The aim is to externalize all hard-coded gui elements from the code but it's a long way before this is a reality. The default text elements of the gui are shipped within the BASE jar files and doesn't have any locale-specific dependency. This means that unless a more specific translation is provided the default texts are always used as a fallback. Most of the default texts are found in property files in the /net/sf/basedb/clients/web/resources directory inside the base-webclient-3.x.jar file. Translations should be located in the same relative path either inside their own JAR file or in the WEB-INF/classes directory. The file names should be extended with the language, country and variant separated with an underscore. For example, files with a swedish translation should be named *_sv.properties, and files with a swedish translation in Finland using the 'foo' variant should be named *_sv_FI_foo.properties.

	Note
	Note that it is valid to have empty values for language and/or country and still specify a variant. Underscores are NOT collapsed. For example, in a swedish translation using the 'foo' variant the files should be named *_sv__foo.properties.

	Important
	All files should be saved in UTF-8 format.

The SSL protocol to use. The default value is TLS.

A security provider implementation. If not specified a suitable default is selected.

The full path to a key-store file. If not specified no key-store is used.

The password for unlocking the keys in the key-store. All keys must use the same password.

The file type of the key-store file. The default value is 'JKS'.

The name of a provider implementation to use for reading the key-store file. If not specified a suitable default is used.

The algorithm used in the key-store file. The default value is 'SunX509'.

The full path to a trust-store certificate file. If not specified the default depends on the key-store setting. If no key-store is configured, the default trust-store is used. If a key-store has been configured no trust-store is used.

The password for unlocking the certificates in the trust-store. All certificates must use the same password.

The file type of the trust-store file. The default value is 'JKS'.

The name of a provider implementation to use for reading the trust-store file. If not specified a suitable default is used.

The algorithm used in the trust-store file. The default value is 'PKIX'.

Enable this option to compress the data files generated by the export. This may improve performance in case disk speed is a limiting factor. Default is to not compress.

The number of rows that should be fetch at the same time from the database. A higher value may increase the performance but uses more memory. The default value is 20000.

Enable this flag to issue an SQL statment for statistical analysis of the imported data before continuing with the next table. Disabling this may result in very poor performance. This option is enabled by default.

Enable this flag to drop the primary key of a table before importing data to it. This may increase the performance. The primary key is re-created after the data has been imported. This option is enabled by default.

Enable this flag to drop unique constraints and indexes before importing data to a table. This may increase the performance. The constraints and indexes are re-created after the data has been imported. NOTE! Foreign key constraints are not affected by this flag, since they must always be dropped. This option is enabled by default.