Database support

The File Server and Client support the following databases:

• Database support
  • Database Scripts
  • Database Configuration
    • Common Properties
    • DB2
    • H2
    • HSQLDB
    • MariaDB
    • MS SQL Server
    • MySQL
    • Oracle
    • PostgreSQL

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 below.

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 drivers here

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>

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>

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 drivers here

Download the right flyway-mysql driver here and add it to the classpath next to the database driver Check the pom.xml of File-Server or File-Client for the right version of the flyway-mysql library

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 Check the pom.xml of File-Server or File-Client for the right version of the flyway-sqlserver library

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 drivers here

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 drivers here

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 drivers here