Database support
The File Server and Client support the following databases:
Database Scripts
The File-Server and File-Client support automatic database migration through Flyway. You have to provide a database user with create table permissions so the tables are created automatically when the application is started for the first time.
The database scripts for the File-Server can also be found here and the database scripts for the File-Server can also be found here.
Database Configuration
You can find the JDBC settings for the supported databases as well as links to the JDBC drivers and Flyway database drivers below. You can add/change the JDBC settings in the application.properties file of the File-Server and File-Client. The application.properties file is located in the config folder of the File-Server and File-Client. You should also add the JDBC driver and the Flyway database driver to the classpath of the File-Server and File-Client. You can do this by adding the JDBC driver and the flyway database driver to the lib folder of the File-Server and File-Client.
Common Properties
jdbc.username=<username>
jdbc.password=<password>
DB2
# JDBC driver
jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
# or XA driver
jdbc.driverClassName=com.ibm.db2.jcc.DB2XADataSource
jdbc.url=jdbc:db2://<host>:<port>/<dbname>
Download JDBC drivers here
Download the right flyway-db2 driver here and add it to the classpath next to the database driver
H2
# JDBC and XA driver
jdbc.driverClassName=org.h2.Driver
# or XA driver
jdbc.driverClassName=org.h2.jdbcx.JdbcDataSource
# In memory
jdbc.url=jdbc:h2:mem:<dbname>
# or file
jdbc.url=jdbc:h2:<path>
# or server
jdbc.url=jdbc:h2:tcp://<host>:<port>/<path>
Download JDBC drivers here
HSQLDB
# JDBC driver
jdbc.driverClassName=org.hsqldb.jdbcDriver
# or XA driver
jdbc.driverClassName=org.hsqldb.jdbc.pool.JDBCXADataSource
# In memory
jdbc.url=jdbc:hsqldb:mem:<dbname>
# or file
jdbc.url=jdbc:hsqldb:file:<path>
# or server
jdbc.url=jdbc:hsqldb:hsql://<host>:<port>/<dbname>
Download JDBC drivers here
Download the right flyway-hsqldb driver here and add it to the classpath next to the database driver
MariaDB
# JDBC driver
jdbc.driverClassName=org.mariadb.jdbc.Driver
# or XA driver
jdbc.driverClassName=org.mariadb.jdbc.MySQLDataSource
jdbc.url=jdbc:mariadb://<host>:<port>/<dbname>
Download JDBC drivers here
Download the right flyway-mysql driver here and add it to the classpath next to the database driver
MS SQL Server
We strongly advise to not use a MSSQL Database with the File-Server or File-Client if you expect a moderate to high message load, because MSSQL cannot handle that because of Page Locking.
# JDBC driver
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
# or XA driver
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerXADataSource
jdbc.url=jdbc:sqlserver://<host>:<port>;[instanceName=<instanceName>;]databaseName=<dbname>;
Download drivers here
Download the right flyway-sqlserver driver here and add it to the classpath next to the database driver
MySQL
# JDBC driver
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
# or XA driver
jdbc.driverClassName=com.mysql.cj.jdbc.MysqlXADataSource
jdbc.url=jdbc:mysql://<host>:<port>/<dbname>
Download JDBC drivers here
Download the right flyway-mysql driver here and add it to the classpath next to the database driver
Oracle
# JDBC driver
jdbc.driverClassName=oracle.jdbc.OracleDriver
# or XA driver
jdbc.driverClassName=oracle.jdbc.xa.client.OracleXADataSource
jdbc.url=jdbc:oracle:thin:@<host>:<port>:<dbname>
Download JDBC drivers here
Download the right flyway-oracle driver here and add it to the classpath next to the database driver
PostgreSQL
# JDBC driver
jdbc.driverClassName=org.postgresql.Driver
# or XA driver
jdbc.driverClassName=org.postgresql.xa.PGXADataSource
jdbc.url=jdbc:postgresql://<host>:<port>/<dbname>
Download JDBC drivers here
Download the right flyway-postgresql driver here and add it to the classpath next to the database driver