Deployment Manual / 3.4.10 Notifications SQL Persistence Configuration

Deployment Manual / Version 2412.0

Table Of Contents

3.4.10 Notifications SQL Persistence Configuration

The following table lists the configuration properties for CoreMedia Notifications with SQL persistence.

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

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

`notification.datasource`
Type	`org.springframework.boot.autoconfigure.jdbc.DataSourceProperties`
Description	Configuration of the data source. See official spring documentation of 'spring.datasource' for more information
`notification.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
`notification.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.
`notification.datasource.password`
Type	`String`
Default	cm_notifications
Description	DB password.
`notification.datasource.url`
Type	`String`
Description	DB jdbc connection url. See official spring documentation of 'spring.datasource.url' for more information.
`notification.datasource.username`
Type	`String`
Default	cm_notifications
Description	DB username.
`notification.deletion.enabled`
Type	`Boolean`
Default	true
Description	Defines if task is enabled.
`notification.deletion.interval`
Type	`Duration`
Default	1h
Description	The interval for task execution. Default unit: seconds.
`notification.deletion.limit`
Type	`Integer`
Default	1000
Description	The batch size limit for deletion.
`notification.deletion.ttl`
Type	`Duration`
Default	180d
Description	The time to live after the task deletes DB entries. Default unit: days.
`notification.invalidation.enabled`
Type	`Boolean`
Default	true
Description	Defines if task is enabled.
`notification.invalidation.error-delay`
Type	`Duration`
Default	1m
Description	The sleep duration in case of an exception. The default unit is seconds.
`notification.invalidation.interval`
Type	`Duration`
Default	5s
Description	The interval for task execution. The default unit is seconds.
`notification.invalidation.limit`
Type	`Integer`
Default	200
Description	The limit of event entities to retrieve.
`notification.invalidation.max-retries-for-missing-ids`
Type	`Integer`
Default	2
Description	Event fetching is based on an auto-incrementing id column and only works correctly when the id increases for each new notification. As this is not guaranteed by the database, the event task will keep trying to obtain notifications for missing ids for this number of task executions.
`notification.jpa`
Type	`org.springframework.boot.autoconfigure.orm.jpa.JpaProperties`
Description	Configuration of the JPA. See official spring documentation of 'spring.jpa' for more information.
`notification.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.
`notification.persistence`
Type	`String`
Default	elastic-core
Description	Persistence mode for notifications, possible values are 'elastic-core' (default) and 'sql'.

Table 3.29. Notification SQL Properties

Search Results

Table Of Contents