/
Database Configuration
Database Configuration
Taskana uses a database to persist the managed entities. When creating this database, you should consider the following items:
- We recommend to create the database with a page size of 32 k
- Be aware that the sort order of query results is governed by the collation sequence that is specified at database creation. The default for the most databases is a case sensitive sort order. If you want query results to be sorted case insensitively, you should specify an appropriate collation sequence.
For DB2, a database create command with case insensitive collation would be
CREATE DATABASE <dbname> USING CODESET UTF-8 TERRITORY <territory> COLLATE USING 'CLDR181_LDE_AS_CX_EX_FX_HX_NX_S3' PAGESIZE 32 K <additional parameters>
The database schema can be changed by setting the parameter "taskana.schema" in the "application.properties" file. This applies to Spring environments, only.
Taskana connects to the database via a DataSource. It does not support XADataSources for connections to databases.
, multiple selections available,
Related content
UI configuration
UI configuration
More like this
Setup and Run
Setup and Run
More like this
Using multiple databases for taskana-core unit tests
Using multiple databases for taskana-core unit tests
More like this
Spring Boot configuration
Spring Boot configuration
More like this
TODO - Wildfly Application Server configuration
TODO - Wildfly Application Server configuration
More like this