hibernate.properties - Atoti Hub

What is the file for?

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 - Appendix A: Configuration Settings.

What are the 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.