File purpose
The hibernate.properties file is used to configure the Content Service database and connections to the Content Server. Hibernate properties are prefixed withcontent-service.db and are used in LocalContentServiceConfig.
For standard field meanings, see Hibernate - Appendix A: Configuration Settings.
File values
| Property | Default value | Description |
|---|---|---|
| content-service.db.hibernate.dialect | org.hibernate.dialect.H2Dialect | SQL dialect used for the Hibernate connection to the content server. |
| content-service.db.hibernate.show_sql | false | Enable/disable the logging of all generated SQL statements to the console. |
| content-service.db.hibernate.format_sql | false | Enable/disable formatting the generated SQL statement. Enabling this makes the statement more readable, but takes up more screen space. |
| content-service.db.hibernate.hbm2ddl.auto | update | Hibernate database schema generation process. Possible values are: none, create-only, drop, create, create-drop, validate, update. |
| content-service.db.hibernate.connection.provider_class | org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl | Implementation of the ConnectionProvider. |
| content-service.db.url | jdbc:h2:%{dbfile};DB_CLOSE_DELAY=-1 | The URL of the Hibernate connection to the content server. |
| content-service.db.file.name | frtb_ref_impl_content_service | The name of the dbfile used in the Hibernate connection URL. %{dbfile}** wildcard on the database URL. |
| content-service.db.defaultAutoCommit | false | The default auto-commit state of connections created by this pool. |
| content-service.db.jakarta.persistence.jdbc.driver | org.h2.Driver | The fully qualified Java class name of the JDBC driver to be used. |
| content-service.db.jdbcInterceptors | org.apache.tomcat.jdbc.pool.interceptor.ConnectionState | A semicolon-separated list of classnames, extending the org.apache.tomcat.jdbc.pool.JdbcInterceptor class. These interceptors will be inserted as an interceptor into the chain of operations on a java.sql.Connection object. |