Taskana support these databases:
| Database | Version |
|---|---|
| DB2 | 10.5 |
| DB2 | 11.1 |
| POSTGRES | 10 latest |
| 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 latest
Please use the configuration in ci folder with the docker compose command. In this configuration the postgres database will be configured with german collation for ordering.
start command
docker-compose -f $scriptDir/docker-compose.yml up -d
taskanaUnitTest.properties
jdbcDriver=org.postgresql.Driver jdbcUrl=jdbc:postgresql://localhost:50102/postgres dbUserName=postgres dbPassword=postgres schemaName=taskana