hibernate.properties

File purpose

The hibernate.properties file is used to configure the Content Service database and connections to the Content Server.

Hibernate properties are prefixed with content-service.db and are used in LocalContentServiceConfig.

For standard field meanings, see Hibernate - Chapter 3. Configuration.

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.