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
For easier setup there are preconfigured docker images. After installing docker just run the following command to start an instance of the specific database:
...
Use preconfigure database docker images
| Info |
|---|
Requirements: Docker on you machine |
In the folder
...
docker-databases you find a prepare_db script which
...
DB2 11.1
...
| language | bash |
|---|---|
| title | start command |
...
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.1
| 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 10 latest
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
docker-compose -f $scriptDir/docker-compose.yml up -d | ||||
| Code Block | ||||
| ||||
jdbcDriver=org.postgresql.Driver jdbcUrl=jdbc:postgresql://localhost<host>:50102<port>/postgres<database> dbUserName=postgres<username> dbPassword=postgres<password> schemaName=taskana |