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 10.5
| Code Block | ||||
|---|---|---|---|---|
| ||||
docker run -d -p 50100:50000 --name taskana-db2_10_5 taskana/db2:10.5 -d |
| Code Block | ||
|---|---|---|
| ||
jdbcDriver=com.ibm.db2.jcc.DB2Driver
jdbcUrl=jdbc:db2://localhost:50100/tskdb
dbUserName=db2inst1
dbPassword=db2inst1-pwd
schemaName=TASKANA |
DB2 11.1
| Code Block | ||||
|---|---|---|---|---|
| ||||
docker run -d -p 50101:50000 --name taskana-db2_11_1 taskana/db2:11.1 -d |
...
| title | taskanaUnitTest.properties |
|---|
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
...
14.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
docker run -d -p 50102:5432 --name taskana-postgres_10_4 -e POSTGRES_PASSWORD=postgres postgres:10.4 |
...
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 |