Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
devel:documentation:application_configuration:dev:backend [2020/01/30 08:39] tomiskar |
devel:documentation:application_configuration:dev:backend [2020/01/31 08:56] tomiskar [Attachment storage] |
||
|---|---|---|---|
| Line 109: | Line 109: | ||
| <code properties> | <code properties> | ||
| - | # audit table suffix | + | # ZonedDateTime is stored in UTC |
| + | spring.jpa.properties.hibernate.jdbc.time_zone=UTC | ||
| + | # Driver (e.g. postgres) does not support contextual LOB creation | ||
| + | spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true | ||
| + | # audit table suffixes | ||
| spring.jpa.properties.org.hibernate.envers.audit_table_suffix=_a | spring.jpa.properties.org.hibernate.envers.audit_table_suffix=_a | ||
| + | spring.jpa.properties.org.hibernate.envers.modified_flag_suffix=_m | ||
| # modified flag for all audited columns | # modified flag for all audited columns | ||
| spring.jpa.properties.org.hibernate.envers.global_with_modified_flag=true | spring.jpa.properties.org.hibernate.envers.global_with_modified_flag=true | ||
| # prevent to modify attributes created, creator etc. | # prevent to modify attributes created, creator etc. | ||
| - | spring.jpa.properties.hibernate.ejb.interceptor=eu.bcvsolutions.idm.core.model.repository.listener.AuditableInterceptor | + | spring.jpa.properties.org.hibernate.envers.audit_strategy=eu.bcvsolutions.idm.core.model.repository.listener.IdmAuditStrategy |
| + | spring.jpa.properties.hibernate.session_factory.interceptor=eu.bcvsolutions.idm.core.model.repository.listener.AuditableInterceptor | ||
| # enable / disable audit (envers) | # enable / disable audit (envers) | ||
| spring.jpa.properties.hibernate.listeners.envers.autoRegister=true | spring.jpa.properties.hibernate.listeners.envers.autoRegister=true | ||
| + | # Spring boot 2 changed default to true, but we are using IDENTITY identifier generators for mssql database. | ||
| + | spring.jpa.hibernate.use-new-id-generator-mappings=false | ||
| # | # | ||
| # DB ddl auto generation by hibernate is disabled - flyway database migration is used | # DB ddl auto generation by hibernate is disabled - flyway database migration is used | ||
| Line 131: | Line 138: | ||
| spring.datasource.testOnBorrow=true | spring.datasource.testOnBorrow=true | ||
| spring.datasource.validationQuery=SELECT 1 | spring.datasource.validationQuery=SELECT 1 | ||
| + | # Enlarge pool size by default. This property should be revised for each project. Size should be configured by task and event thread pool size - should be higher than sum of pool sizes. | ||
| + | spring.datasource.hikari.maximumPoolSize=50 | ||
| </ | </ | ||
| Line 217: | Line 226: | ||
| # temporary file time to live in milliseconds | # temporary file time to live in milliseconds | ||
| # older temporary files will be purged, default 14 days | # older temporary files will be purged, default 14 days | ||
| + | # Temporary file is used mainly for upload files internaly. When upload is complete, then temporary file is moved into normal IdM attachment (~ temporary file is not reachable, after user session ends). | ||
| idm.sec.core.attachment.tempTtl=1209600000 | idm.sec.core.attachment.tempTtl=1209600000 | ||
| </ | </ | ||