By default, Flowable Work is configured to run with a built-in H2 database
located in a folder
flowable-db in your home directory.
On Unix or macOS this is
If you want to change the location of the H2 database then add the following line
flowable-db to your preference) to the
created previously in the
The Flowable Work application is a Spring Boot 2.1 application
and can be configured in the standard Spring Boot fashion.
This means that the database can be configured by setting the following
properties in the
application.properties file created previously:
spring.datasource.driver-class-name=<jdbc driver> spring.datasource.url=<jdbc URL> spring.datasource.username=<username> spring.datasource.password=<password>
Here are example JDBC URLs for common databases:
Flowable Work does not ship any JDBC drivers other than one for
the H2 database.
Therefore, you need to download the appropriate JDBC driver and copy it to the Tomcat’s
lib folder before starting Tomcat.
Example for setting up PostgreSQL
Download and install PostgreSQL from https://www.postgresql.org/download/.
Copy the JDBC driver for PostgreSQL (from https://jdbc.postgresql.org/download.html) to the
libdirectory of the Tomcat instance.
psqland create a user and a database:
CREATE ROLE flowable WITH LOGIN PASSWORD 'flowable'; CREATE DATABASE flowable; GRANT ALL PRIVILEGES ON DATABASE flowable TO flowable;
Add the JDBC URL, driver, username and password of the schema you just created to the
application.propertiesfile in the
libfolder of your Tomcat installation.
spring.datasource.driver-class-name=org.postgresql.Driver spring.datasource.url=jdbc:postgresql://localhost:5432/flowable spring.datasource.username=flowable spring.datasource.password=flowable