Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Taskana support these databases:

...

By default the unit tests will run with the H2 in memory 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

...

Use preconfigured database docker images

...

Info

Requirements: Docker on you machine

In the folder 

...

docker-databases you find a prepare_db script which

...

DB2 11.1

Code Block
languagebash
titlestart command
 docker run -d -p 50101:50000 --name taskana-db2_11_1 taskana/db2:11.1 -d

...

starts the requested database and create the appropriate taskanaUnitTest.properties file for you. 

*nix (prepare_db.sh)

Execute ./docker-databases/prepare_db.sh -h and follow the help output for that script. It tells you how it works and which databases can be used

Windows (prepare_db.bat)

Just execute the file. This is an interactive bat file which provides all the options for you.

Examples for taskanaUnitTest.properties

DB2 11.5

taskanaUnitTest.properties
Code Block
jdbcDriver=com.ibm.db2.jcc.DB2Driver
jdbcUrl=jdbc:db2://localhost<host>:50101<port>/tskdb<database>
dbUserName=db2inst1<username>
dbPassword=db2inst1-pwd<password>
schemaName=TASKANA

POSTGRES

...

Info

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.

Code Block
languagebash
titlestart command
docker-compose -f $scriptDir/docker-compose.yml up -d

...

14.7

taskanaUnitTest.properties
Code Block
jdbcDriver=org.postgresql.Driver
jdbcUrl=jdbc:postgresql://localhost<host>:50102<port>/postgres<database>
dbUserName=postgres<username>
dbPassword=postgres<password>
schemaName=taskana