Database Settings

Options in this group control how LinkServer stores its data in the database.

Database driver

Key name in the configuration file: databaseDriver

Value type: String

Possible values: Any Java class name corresponding to a JDBC driver

Default value: org.hsqldb.jdbcDriver

This option defines which JDBC (Java Database Connectivity) database driver will be used. For example, to use MySQL database for data storage set this option to "com.mysql.jdbc.Driver". Consult JDBC driver documentation to find out the proper value.

Database URL

Key name in the configuration file: databaseUrl

Value type: String

Possible values: Database-dependent path string

Default value: jdbc:hsqldb:file:db/LinkServer

This is a database-specific string that defines the database type, the file system path (local or network) to a database containing LinkServer data tables and any additional options. To figure out the correct value for your selected JDBC database driver, please consult its documentation. The default value for this option makes LinkServer use its embedded HSQL database to store data in ordinary text files in the db/ subdirectory of the LinkServer installation.

Database username

Key name in the configuration file: databaseUsername

Value type: String

Possible values: Any username suitable for the database server

Default value: sa

This option defines which username is used to log on to the database server. The default value allows connection to LinkServer's embedded database server.

Database password

Key name in the configuration file: databasePassword

Value type: String

Possible values: Any password suitable for the database server

Default value: "" (empty)

This option defines which password is used to log on to the database server. The default value allows connection to LinkServer's embedded database server

Database SQL dialect

Key name in the configuration file: databaseSqlDialect

Value type: String

Possible values:

Default value: HSQLDialect

This option defines the Java class name for the database SQL dialect. For example, use MySQLDialect if you use MySQL database to store data. If your database server is not listed in the table above, please contact the technical support team.