Taskana support these databases:
| Database | Version |
|---|---|
| DB2 | 10.5 |
| DB2 | 11.1 |
| POSTGRES | 10.4 |
| H2 | - |
By default the unit tests will run with the H2 database. If you want to run the tests with a different database you have to create the taskanaUnitTest.properties file in your home directory.
That file must contain the following information:
- jdbcDriver
- jdbcUrl
- dbUserName
- dbPassword
- schemaName
For easier setup there are preconfigured docker images. After installing docker just run the following command to start an instance of the specific database:
In the folder ci you find a prepare_db script which already does all of the listed below. (bash for *nix users and batch for windows users).
DB2 10.5
start command
docker run -d -p 50100:50000 --name taskana-db2_10_5 taskana/db2:10.5 -d
taskanaUnitTest.properties
jdbcDriver=com.ibm.db2.jcc.DB2Driver jdbcUrl=jdbc:db2://localhost:50100/tskdb dbUserName=db2inst1 dbPassword=db2inst1-pwd schemaName=TASKANA
DB2 11.1
start command
docker run -d -p 50101:50000 --name taskana-db2_11_1 taskana/db2:11.1 -d
taskanaUnitTest.properties
jdbcDriver=com.ibm.db2.jcc.DB2Driver jdbcUrl=jdbc:db2://localhost:50101/tskdb dbUserName=db2inst1 dbPassword=db2inst1-pwd schemaName=TASKANA
POSTGRES 10.4
start command
docker run -d -p 50102:5432 --name taskana-postgres_10_4 -e POSTGRES_PASSWORD=postgres postgres:10.4
taskanaUnitTest.properties
jdbcDriver=org.postgresql.Driver jdbcUrl=jdbc:postgresql://localhost:50102/postgres dbUserName=postgres dbPassword=postgres schemaName=taskana