Change Database Engine

By default this reference implementation of Arrowhead FW provides MySQL database engine connector, however the source code itself is written to be database-agnostic. This means that you can switch the underlying database without changing much of the code.

1) Change the database connector dependency

Change this dependency definition in the root pom.xml.

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>${mysql.jdbc.driver}</version>
	<scope>runtime</scope>
</dependency>

to MariaDB

<dependency>
	<groupId>org.mariadb.jdbc</groupId>
	<artifactId>mariadb-java-client</artifactId>
	<scope>runtime</scope>
</dependency>

to PostgreSQL

<dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
	<scope>runtime</scope>
</dependency>

2) Change the system configurations

Change the following properties in the src/main/resources/application.properties configuration file in case of each core system.

spring.datasource.url=jdbc:mysql://<address>:<port>/<database-name>  

to MariaDB

spring.datasource.url=jdbc:mariadb://<address>:<port>/<database-name>  

to PostgreSQL

spring.datasource.url=jdbc:postgresql://<address>:<port>/<database-name>