Deployment Manual / 3.4.11 Projects/To-Dos SQL Persistence Configuration

Deployment Manual / Version 2412.0

Table Of Contents

3.4.11 Projects/To-Dos SQL Persistence Configuration

The following table lists the configuration properties for CoreMedia Projects/To-Dos with SQL persistence.

The most important property is project.datasource.url which sets the URL to connect to.

In case another username, or password has to be configured use the properties project.datasource.username, project.datasource.password.

`project.datasource`
Type	`org.springframework.boot.autoconfigure.jdbc.DataSourceProperties`
Description	Configuration of the data source. See official spring documentation of 'spring.datasource' for more information
`project.datasource.hikari`
Type	`com.zaxxer.hikari.HikariDataSource`
Description	Configuration of the Hikari data source. See official spring documentation of 'spring.datasource.hikari' for more information
`project.datasource.hikari.connection-timeout`
Type	`Integer`
Default	20000
Description	Hikari connection timeout in ms. Value must not be greater than the studio request timeout. See official spring documentation of 'spring.datasource.hikari.connection-timeout' for more information.
`project.datasource.password`
Type	`String`
Default	cm_projects
Description	DB password.
`project.datasource.url`
Type	`String`
Description	DB jdbc connection url. See official spring documentation of 'spring.datasource.url' for more information.
`project.datasource.username`
Type	`String`
Default	cm_projects
Description	DB username.
`project.entity.deletion.enabled`
Type	`Boolean`
Default	true
Description	Defines if task is enabled.
`project.entity.deletion.interval`
Type	`Duration`
Default	1h
Description	The interval for task execution. Default unit: seconds.
`project.entity.deletion.limit`
Type	`Integer`
Default	1000
Description	The batch size limit for deletion.
`project.entity.deletion.ttl`
Type	`Duration`
Default	1d
Description	The time to live after the task deletes project and todo DB entries, that are marked for deletion. Default unit: days.
`project.event.deletion.enabled`
Type	`Boolean`
Default	true
Description	Defines if task is enabled.
`project.event.deletion.interval`
Type	`Duration`
Default	1h
Description	The interval for task execution. Default unit: seconds.
`project.event.deletion.limit`
Type	`Integer`
Default	1000
Description	The batch size limit for deletion.
`project.event.deletion.ttl`
Type	`Duration`
Default	1d
Description	The time to live after the task deletes DB entries. Default unit: days.
`project.invalidation.enabled`
Type	`Boolean`
Default	true
Description	Defines if event processing is enabled.
`project.invalidation.error-delay`
Type	`Duration`
Default	1m
Description	The sleep duration in case of an exception. The default unit is seconds.
`project.invalidation.interval`
Type	`Duration`
Default	1s
Description	The interval for task execution. The default unit is seconds.
`project.invalidation.limit`
Type	`Integer`
Default	200
Description	The limit of event entities to retrieve.
`project.invalidation.max-retries-for-missing-ids`
Type	`Integer`
Default	5
Description	Event fetching is based on an auto-incrementing id column and only works correctly when the id increases for each new project event. As this is not guaranteed by the database, the event task will keep trying to obtain project events for missing ids for this number of task executions.
`project.invalidation.remote-enabled`
Type	`Boolean`
Default	true
Description	Defines if remote event processing is enabled. Required for a setup with multiple studio-server instances.
`project.jpa`
Type	`org.springframework.boot.autoconfigure.orm.jpa.JpaProperties`
Description	Configuration of the JPA. See official spring documentation of 'spring.jpa' for more information.
`project.jpa.properties.hibernate.jdbc.time_zone`
Type	`String`
Default	UTC
Description	Configuration of the default timezone. See official spring documentation of 'spring.jpa.properties.hibernate.jdbc.time_zone' for more information.

Table 3.30. Project SQL Properties

Search Results

Table Of Contents